HELP - SQLDMO Problem

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
_dino_
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
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:u10ch11m71na02qksua5dr68uofcv3qi3o@.4ax.com...
> 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
> _dino_
|||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"
<hilary.cotter@.gmail.com> wrote:

>try going to this location via a command window
>C:\Program Files\Microsoft SQL Server\80\Tools\Binn
>and type regsvr32 sqldmo.dll
|||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
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:oqfeh1tjdu4fi03trd0eka0t7bi4qk1g5v@.4ax.com...
> 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"
> <hilary.cotter@.gmail.com> wrote:
>
|||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"
<hilary.cotter@.gmail.com> wrote:

>Try putting the sever name in using Client Network Utility and enter the IP
>address there.