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

sql server full text search : HELP - SQLDMO Problem


Dino Buljubasic
8/31/2005 7:11:21 PM
Hi,

I am using SQLDMO in my application to create data tables, full-text
catalogs and jobs to populate the catalogs. My datatables are created
successfully but I get error on line where it says :

Dim oSQLServer as SQLDMO.SQLServer
oSQLServer = new SQLDMO.SQLServer

I have added reference to SQLDMO library (Name: Interop.SQLDMO) in my
project (VB.NET 2003, Framework 1.1)

The error message is:
System.RuntimeInteropServices.COMException (0x80040154)
COM Object with CLSID {classId} is either not valid or not registered.
Stack Trace points to line oSQLServer = new SQLDMO.SQLServer

How do I fix this problem? (i.e. how do I register this COM object)

I dont have this problem when I run my app from VS.NET Studio (so with
machine with installed VS.NET) but it occurs on a machine without
VS.NET) when I run the executable file inside bin directory (which
also contains Interop.SQLDMO.dll file)

Any help will be appreciated
Hilary Cotter
8/31/2005 8:56:08 PM
try going to this location via a command window

C:\Program Files\Microsoft SQL Server\80\Tools\Binn

and type regsvr32 sqldmo.dll

--
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
9/1/2005 12:00:00 AM

Hillary,

thank you for your help. The sql client tools have been installed on
the machine and we tested it in the office at several machines and it
worked just fine; however, on client's side it would not work.

The only difference is that at the office, we provided server name
instead of IP address. Today, we tried the same at clients side and
it works just fine. Why would SQLDMO accept server name but not
server IP address??? Any Ideas ???

I appreciate your help
_dino_

On Wed, 31 Aug 2005 20:56:08 -0400, "Hilary Cotter"
[quoted text, click to view]
Hilary Cotter
9/1/2005 12:00:00 AM
Try putting the sever name in using Client Network Utility and enter the IP
address there.

--
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
9/1/2005 9:24:55 PM
Thanks, I'll try it next time on client's site

I appreciate your help
_dino_


On Thu, 1 Sep 2005 14:13:13 -0400, "Hilary Cotter"
[quoted text, click to view]
AddThis Social Bookmark Button