sqldmo failed to register

[Michael Tissington]

I have an install which works on 99.9% of machines (98, 2000, XP)

On one Windows 2000 (SP4) machine my install gets an error when trying to
register sqldmo.dll
the error is 0x80040154 (Class Not Registered).

I run depends on the machine and everything is in place.

Obviously I'm installing all the .rll files because this works on all but
this machine.

Any ideas please?

[Mingqing Cheng [MSFT]]

Hi Michael,

From your descriptions, I understood that you could not register sqldml.dll
on one machine with returned code: 0x80040154. Have I understood you? If
there is anything I misunderstood, please feel free to let me know:)

First of all, what's the version of MDAC on your Windows 2000? You should
make the latest version of MDAC, which could be found at the following
documents
Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

Secondly, would you please have a check on your IE versions? Would you
please make the latest patch of Internet Expoloerer, which could be get for
the documents below if you are using IE6

Internet Explorer 6 Service Pack 1
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e1550cb-5e5d-48f5-
b02b-20b602228de6&displaylang=en

Thirdly, do you have .net framework installed after SQL Server Installed?
Is it possible to try a reinstall of SQL Server? Would you please show me
your detailed steps, which will make us closer to the resolutions.

Finally, make sure that the following files were under \WINNT\system32:
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.dl (seen from
Dependency
Walker)
and make sure that the following file was under
\WINNT\system32\Resources\1033 (will need to create the 'Resources' folder
and the '1033' subfolder):
sqldmo.rll

Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
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, many thanks!

[Michael Tissington]

I have installed MDAC 2.8

I have also installed IE 6.0 and then did a windowsupdate to install all the
various patches.

I am NOT installing SQL Server.
I just need to install sqlredis.exe and sqldmo components.

I'm not installing sqldmo files under WINNT.
I am installing them in C:\Program Fiels\Microsoft SQL Server\80\Tools\Binn
The Resources folder and 1033 are present with the required rll files.

The ONLY file that dependency walker questions is apphelp.dll and mpr.dll

Warning: At least one delay-load dependency module was not found.
Warning: At least one module has an unresolved import due to a missing
export function in a delay-load dependent module.

Any ideas please ?
--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

Post by Mingqing Cheng [MSFT]
Hi Michael,
From your descriptions, I understood that you could not register sqldml.dll
on one machine with returned code: 0x80040154. Have I understood you? If
there is anything I misunderstood, please feel free to let me know:)
First of all, what's the version of MDAC on your Windows 2000? You should
make the latest version of MDAC, which could be found at the following
documents
Microsoft Data Access Components (MDAC) 2.8

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-

Post by Mingqing Cheng [MSFT]
b037-185d0506396c&DisplayLang=en
Secondly, would you please have a check on your IE versions? Would you
please make the latest patch of Internet Expoloerer, which could be get for
the documents below if you are using IE6
Internet Explorer 6 Service Pack 1

http://www.microsoft.com/downloads/details.aspx?FamilyID=1e1550cb-5e5d-48f5-

Post by Mingqing Cheng [MSFT]
b02b-20b602228de6&displaylang=en
Thirdly, do you have .net framework installed after SQL Server Installed?
Is it possible to try a reinstall of SQL Server? Would you please show me
your detailed steps, which will make us closer to the resolutions.
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.dl (seen from
Dependency
Walker)
and make sure that the following file was under
\WINNT\system32\Resources\1033 (will need to create the 'Resources' folder
sqldmo.rll
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
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, many thanks!

[Mingqing Cheng [MSFT]]

Hi Michael,

Thanks for your prompt updates!

It seems strange that you could not register it successfully on Windowns
2000. I have to make the following steps checking what's wrong

1. Could you ensure that those DLL files are file and could be working fine
in other machines (the files are listed below)?

2. Would you please so kind as to check the folloing files again? (I
understand you must have do this, but considering this strange issue, would
you please do it again?)
Distributed Management Objects (DMO)
----------------------------------------------
File Name Description
----------------------------------------------
sqldmo.dll Distributed Management Objects COM
sqldmo.rll Distributed Management Objects Resource File
sqlresld.dll SQL Enterprise Manager Resource DLL Loader
sqlsvc.dll Database Service Layer
sqlsvc.rll Database Service Layer Resource DLL
sqlunirl.dll SQL Server Unicode/ANSI Translation Layer
w95scm.dll SQL Service Control Manager Abstraction Layer

3. Would you please try to install SQL Server Client? Could it be installed
successfully? If not, what's the error message?

4. As I could not reproduce it on my machine, could you specify some
difference between this machine with other machine?

Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are here to be of assistance!

Sincerely yours,

Mingqing Cheng
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, many thanks!

[Mingqing Cheng [MSFT]]

Hi Michael,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!

If you have any questions or concerns, don't hesitate to let me know. We
are here to be of assistance!

Sincerely yours,

Mingqing Cheng
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, many thanks!

[Andrea Montanari]

hi Michael,

Post by Michael Tissington
I have an install which works on 99.9% of machines (98, 2000, XP)
On one Windows 2000 (SP4) machine my install gets an error when trying to
register sqldmo.dll
the error is 0x80040154 (Class Not Registered).
I run depends on the machine and everything is in place.
Obviously I'm installing all the .rll files because this works on all but
this machine.
Any ideas please?

you did not post the files you install =;-)
I usually deply the follwong components:
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\odbcbcp.dll; DestDir: WinSys ; sharedfile
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\sqlwoa.dll ; DestDir: WinSys
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\sqlwid.dll ; DestDir: WinSys
..\Programmi\Microsoft SQL Server\80\Tools\Binn\w95scm.dll; DestDir:
DestinationFolder\Binn
..\WINDOWS\SYSTEM\sqlunirl.dll ; DestDir: WinSys
..\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlresld.dll; DestDir:
DestinationFolder\Binn
..\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlsvc.dll; DestDir:
DestinationFolder\Binn
; not licensed by redist.txt but available after installation of MDAC2.6
..\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlsvc.RLL;
DestDir: DestinationFolder\Binn\Resources\1033
; not licensed by redist.txt but available after installation of MDAC2.6
..\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Sqldmo.rll;
DestDir: DestinationFolder\Binn\Resources\1033
..\Programmi\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll; DestDir:
DestinationFolder\Binn ; file to be registered via regserver

the file quoted with ; "not licensed by redist.txt" are not redistrubutable
but are deployed via MDAC distribution..

DestinationFolder can either be the installation directory of one instance
of Microsoft SqlServer 2000, like ..\Program Files\Microsoft SQL
Server\80\Tools, even if no istance of SQL Server has been installed, or the
installation directory of your application, but not suggested. Please do
respect the hierarchy \Binn\Resources\1033 (where 1033 specifies the
language), where needed, in order to grant correct functionality of
Ole-Automation objects.

In order to install SQL-DMO components for MSDE 2000, Microsoft Internet
Explorer 5.5 or higher is required.

[Michael Tissington]

Thanks. However I'm installing all the correct files - like I said this
install works in 99.9% of the cases.

I just have one Windows 2000 (SP4) machine where registering sqldmo.dll
fails
--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

Post by Andrea Montanari
hi Michael,

Post by Michael Tissington
I have an install which works on 99.9% of machines (98, 2000, XP)
On one Windows 2000 (SP4) machine my install gets an error when trying to
register sqldmo.dll
the error is 0x80040154 (Class Not Registered).
I run depends on the machine and everything is in place.
Obviously I'm installing all the .rll files because this works on all but
this machine.
Any ideas please?

you did not post the files you install =;-)
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\odbcbcp.dll; DestDir: WinSys ; sharedfile
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\sqlwoa.dll ; DestDir: WinSys
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\sqlwid.dll ; DestDir: WinSys
DestinationFolder\Binn
..\WINDOWS\SYSTEM\sqlunirl.dll ; DestDir: WinSys
DestinationFolder\Binn
DestinationFolder\Binn
; not licensed by redist.txt but available after installation of MDAC2.6
..\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlsvc.RLL;
DestDir: DestinationFolder\Binn\Resources\1033
; not licensed by redist.txt but available after installation of MDAC2.6
..\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Sqldmo.rll;
DestDir: DestinationFolder\Binn\Resources\1033
DestinationFolder\Binn ; file to be registered via regserver
the file quoted with ; "not licensed by redist.txt" are not

redistrubutable

Post by Andrea Montanari
but are deployed via MDAC distribution..
DestinationFolder can either be the installation directory of one instance
of Microsoft SqlServer 2000, like ..\Program Files\Microsoft SQL
Server\80\Tools, even if no istance of SQL Server has been installed, or the
installation directory of your application, but not suggested. Please do
respect the hierarchy \Binn\Resources\1033 (where 1033 specifies the
language), where needed, in order to grant correct functionality of
Ole-Automation objects.
In order to install SQL-DMO components for MSDE 2000, Microsoft Internet
Explorer 5.5 or higher is required.
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply