SQL Error - PLEASE HELP

  • Thread starter Thread starter Dino Buljubasic
  • Start date Start date
D

Dino Buljubasic

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_
 
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_
 
Back
Top