I am trying to install SQL-DMO using the instruction to register the SQL-DMO components on a client computer. I am using the SQL-DMO components to find all the SQL servers on the network. This list is used by the user in making their connection. When I execute the REGSVR32 SQLDMO.DLL command the following message is return by REGSVR3

LoadingLibrary("SQLDMO.DLL") Failed - The specified module could not be found

Well it is right there in my current directory(C:\Microsoft SQL Server\80\Tools\Binn\Resources\1033

Thanks Bill

Articles 326613 and 248241 were exactly what I needed. What lead me astray was the article on installing SQL-DMO http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con01_8eun.asp I suggest this article/document be update with the information from or a reference to the two articles you told me about

Again, Thanks for the quick response

Jim Meeha

Hello Jmeehan,

From your description, I understand that when you registered SQL-DMO components using
REGSVR32.EXE on a client computer, you received the LoadingLibrary Failed message - "The specified
module could not be found". However, the SQLDMO.DLL file is present in the correct directory.

====================================================

Based on my experience, there are some suitations that will cause this problem. Please follow the
instructions below to troubleshoot your issue:

1) Made sure that the following files were under \WINNT\system32 Or \Windows\system32 (depends on
your Operating System Edition):

sqldmo.dll Distributed Management Objects COM
sqlresld.dll SQL Enterprise Manager Resource DLL Loader
sqlsvc.dll Database Service Layer
sqlsvc.rll Database Service Layer Resource DLL
sqlwoa.dll SQL Server Unicode/ANSI Translation Layer
sqlwid.dll SQL Server Unicode/ANSI Translation Layer
sqlunirl.dll SQL Server Unicode/ANSI Translation Layer
w95scm.dll SQL Service Control Manager Abstraction Layer
odbcbcp.dll ODBC DLL needed by sqlsvc.dll

2) Made sure that the following file was under \WINNT\system32\Resources\1033 (may need to create the
'Resources' folder and the '1033' subfolder):

sqldmo.rll


Normally, all required SQL-DMO components are installed as part of an instance of
SQL Server 2000 server or client. For more information, please refer to the following Knowledge Base (KB)
article:

326613 How to distribute and how to install SQL-DMO for SQL Server 2000
http://support.microsoft.com/?id=326613

============================

If the SQL Server Client Utilities haven't been installed on the client computers, we need to follow the steps
necessary to enable SQL-DMO client side functionality. See the following article for details:

248241 INF: Enabling SQL DMO Clients Without Installing the Client Side
http://support.microsoft.com/?id=248241


Please apply the suggestions in the KB articles and let us know if this helps resolve your problem. If there is
anything more I can do to assist you, please feel free to post it in the group.

Regards,

Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Thanks Jim,

I'm glad that the articles provided to you are helpful to resolve your problem. In addition, it is really a great
idea to update the document with a further reference to those two KB articles.

I appreciate your recommendation and believe you can send this golden idea to Microsoft via the following
Microsoft Product Feedback Web site:

http://register.microsoft.com/mswish/suggestion.asp

Thank you Jim for letting us know how we can improve our documents.

Best regards,

Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Hi,

i am trying to write a install file for an vb6 application wich uses
the sqldmo.dll and i did all what i found in the both articles above
.... The application is working fine - but the bulk insert (csv-file
with format-file) does not work. Only if i install the SQL server
client utilities the records appears in the database ... What can i do
?! Any help would be greate cause my customer don't want to install the
client utilities ...

Thanks a lot & Regards,

Johannes



--
jdrachenfels
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message543647.html