SQL Error - PLEASE HELP

Hi,

My app (VB.NET, .NET Framework 1.1) intalls database tables for a
database. Then it is supposed to create full-text catalogs. It works
well on my machine but not on another machine.

here is error message I get:
An unhandled exception of type
'System.Runtime.InteropServices.COMException' occured in
microsoft.visualbasic.dll
Additional informatioN: [Microsoft][ODBC SQL Server Driver][SQL
Server]The sepcified @server_name (IPAddress) does not exist.

I use within my code :
dim oSQLServer = CreateObject("SQLDMO.SQLServer")
oSQLServer.Connect(strServer, strUserID, strPassword)

to create sqlserver object and connect to it in order to proceed with
creating my full-text catalogs.

As mentioned previously, this application works perfectly on my
machine, but not on another.

Any help will be appreciated
_dino_

MiloszSkalecki
Tue Aug 30 16:08:05 CDT 2005

Greetings,

Hard to say :] Seems something is blocking outgoing connection. Is 1433 port
blocked?
--
Milosz Skalecki
MCP, MCAD


"Dino Buljubasic" wrote:

> Hi,
>
> My app (VB.NET, .NET Framework 1.1) intalls database tables for a
> database. Then it is supposed to create full-text catalogs. It works
> well on my machine but not on another machine.
>
> here is error message I get:
> An unhandled exception of type
> 'System.Runtime.InteropServices.COMException' occured in
> microsoft.visualbasic.dll
> Additional informatioN: [Microsoft][ODBC SQL Server Driver][SQL
> Server]The sepcified @server_name (IPAddress) does not exist.
>
> I use within my code :
> dim oSQLServer = CreateObject("SQLDMO.SQLServer")
> oSQLServer.Connect(strServer, strUserID, strPassword)
>
> to create sqlserver object and connect to it in order to proceed with
> creating my full-text catalogs.
>
> As mentioned previously, this application works perfectly on my
> machine, but not on another.
>
> Any help will be appreciated
> _dino_
>
>

Dino
Tue Aug 30 16:23:06 CDT 2005


Port 1433 is for internet connection, we are working on local area
network, ...also there is no firewall

On Tue, 30 Aug 2005 14:08:05 -0700, Milosz Skalecki
<MiloszSkalecki@discussions.microsoft.com> wrote:

>Greetings,
>
>Hard to say :] Seems something is blocking outgoing connection. Is 1433 port
>blocked?

Bob
Tue Aug 30 21:13:57 CDT 2005

Dino:

I know I may sound stupid for asking because you already said no firewall.

Does the workstation in question have NIS or Mcafee firewall?

Bob

MiloszSkalecki
Wed Aug 31 04:07:01 CDT 2005

Dino,

If you don't set MSSQL port yourself, MSSQL server listens on port 1433 (or
very close number). Please download process explorer from
www.sysinternals.com and check it yourself. I still recon something is
blocking outgoing connections, so ensure port is not beeing blocked by
firewall.

--
Milosz Skalecki
MCP, MCAD


"Dino Buljubasic" wrote:

>
> Port 1433 is for internet connection, we are working on local area
> network, ...also there is no firewall
>
> On Tue, 30 Aug 2005 14:08:05 -0700, Milosz Skalecki
> <MiloszSkalecki@discussions.microsoft.com> wrote:
>
> >Greetings,
> >
> >Hard to say :] Seems something is blocking outgoing connection. Is 1433 port
> >blocked?
>
>

Dino
Wed Aug 31 10:41:24 CDT 2005


Hi Milosz,
Nothing is blocking the connection since my application does
following:

1. It creates data tables

Then it proceeds to create full-text catalogs (4 in total);

2. It creates server object
2. It creates 1st of 4 Full-Text Catalogues and adds it to
SQLSErver.Databases.FullTextCatalogs collection
3. Then it creates job and job schedule and job step for this
catalogue population (oJob, oJobSchedule, oJobStep)
4. It adds job to oSQLServer.JobServer.Jobs colection
5. It adds job step to oJob.JobSteps collection
6. Sets JobSchedule ActiveStartDate, FrequencyInterval, FrequencyType,
FrequencySubDay, FrequencySubDayInterval properties
7. Then it executes:
oJob.BeginAlter()
oJob.JobSchedules.Add(oJobSchedule)
oJob.DoAlter()
oJob.ApplyToTargetServer(serverName) // this is line that is
highlighted when app crashes, so problem is in the line above
(oJobDoAlter())

After the crash, we can observe that data tables have been installed
inside database, the first full-text catalog exists too, the job for
this first full-text catalog exists and job scheduler exists (1 of
4). Therefore, nothing is blocking connection.

It is all at local area network, so no firewalls.

Any ideas?

I appreciate your help
_dino_



On Wed, 31 Aug 2005 02:07:01 -0700, Milosz Skalecki
<MiloszSkalecki@discussions.microsoft.com> wrote:

>Dino,
>
>If you don't set MSSQL port yourself, MSSQL server listens on port 1433 (or
>very close number). Please download process explorer from
>www.sysinternals.com and check it yourself. I still recon something is
>blocking outgoing connections, so ensure port is not beeing blocked by
>firewall.