SQL Error - PLEASE HELP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dino Buljubasic - 30 Aug 2005 22:28 GMT

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_

Reply to this Message

Hilary Cotter - 30 Aug 2005 22:38 GMT

It almost sounds like you are using the wrong server name on the second
server. Can you verify it is correct?

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 21 lines]
> Any help will be appreciated
> _dino_

Reply to this Message

Dino Buljubasic - 30 Aug 2005 23:22 GMT

I dont think so because last time I tryid running it, it created
catalog on one table but than error occured. ( I need to create
search catalog and populate it on several tables)

Thank you

>It almost sounds like you are using the wrong server name on the second
>server. Can you verify it is correct?

Reply to this Message