Groups | Blog | Home
all groups > sql server full text search > august 2005 >

sql server full text search : SQL Error - PLEASE HELP


Hilary Cotter
8/30/2005 5:38:22 PM
It almost sounds like you are using the wrong server name on the second
server. Can you verify it is correct?

--
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

[quoted text, click to view]

Dino Buljubasic
8/30/2005 9:28:02 PM
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 Buljubasic
8/30/2005 10:22:59 PM
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


On Tue, 30 Aug 2005 17:38:22 -0400, "Hilary Cotter"
[quoted text, click to view]
AddThis Social Bookmark Button