SQLDMO.dll

6 Oct 2006 9:39 AM

SalamElias

I have a an exe that references "SQLDMO.DLL" which works fine on a server
having sql 2000 setup on.
I need to run this exe from a server where there is no sql server installed,
I copied the sqldmo to this server and tried to register it as follows
SQLDMO.DLL
tried

>regsvr32 "C:\localbin\dlls\SQLDMO.DLL"

I get a registration error indicating 'Failed to initialize
routine............."
So what are the requirements to be able to make it run in standalone....
thanks in advance

9 Oct 2006 2:37 AM

Charles Wang[MSFT]

Hi,
My understanding of your issue is:
You wanted to register SQLDMO.dll at your client computer without
installing SQL Server. When you used the utility regsvr32 to register it,
you encountered the error 'Failed to initialize routine'.
If I have misunderstood, please let me know.

As far as I know, if you want to register SQLDMO.dll, you still need to
copy its related DLLs to your client computer.
Following is the list of SQL-DMO related DLLs that you need to enable DMO
from a client:
Sqldmo.dll
Sqldmo.rll
Sqlsvc.dll
Sqlsvc.rll
Sqlwoa.dll
Sqlresld.dll
Sqlwid.dll
W95scm.dll

From the preceding list of DLLs, the Sqldmo.dll is the only one that you
need to register on the client computer. However, in order to successfully
register the Sqldmo.dll file, the Sqldmo.rll file must be present on the
client computer in the following directory:
(server side location): c:\Mssql7\Binn\Resources\1033 or
C:\Program Files\Microsoft SQL
Server\80\Tools\binn\Resources\1033
(client side location): c:\Winnt\System32\Resources\1033

For more information, you can refer to this article:
INF: Enabling SQL DMO Clients Without Installing the Client Side Utilities
http://support.microsoft.com/kb/248241/en-us

If this issue persists, I recommend that you install SQL Server client
tools at your client computer.

If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================