Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server 2000 SQL-DMO runtime files

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-15 : 09:00:10
JFP writes "Hi !

I have a VB application that uses SQL-DMO. I read the Microsoft KB Article Q248241 (Enabling SQL DMO Clients without installing the client side utilities).
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q248241

Shortly, it lists which files to copy on a PC, and which one to register (only sqldmo.dll).

That fact is that this article applies to SQL 7.0, but not SQL 2000.

So I copied the files (SQL 2000 version), but when I am trying to register sqldmo.dll, nothing happens. I get no message, and regsvr32 never appears in the computer processes. Of course, my application gets an error 429 (ActiveX component can't create object) when calling CreateObject("SQLDMO.SQLServer").

The PC is running with Windows 2000 SP2. There is also few runtime files to run Visual Basic applications. We use MDAC 2.5, but switching to MDAC 2.6 changed nothing.

Thank you for your help !"
   

- Advertisement -