SQLDMO Failed still fails to register

[Michael Tissington]

I'm still having problems trying to install sqldmo on a couple of client
machines

The files I'm installing are

sqldmo.dll
Resources\1033\sqldmo.rll
sqlresld.dll
sqlsvc.dll
Resources\1033\sqlsvc.rll
sqlunirl.dll
sqlwid.dll
sqlwoa.dll
w95scm.dll

When I attmempt to register it I get an error 80040154 back

I can install MSDE without any problems but I still can not register
sqldmo.dll

However I can install SQL Server client compnents without any problems.

Any idea what else the SQL Server Client install is doing or adding.

(this seems to be a problem specific to about 6 machines, other than that
the install works fine)

Thanks.

[Michael Tissington]

P.S. After closer investigation it appears that an install of the SQL client
tools does NOT do a self register of sqldmo.dll - instead the install loads
the registry directly with a list of values which probably explains why it
works on my 'problem' machines.
--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

Post by Michael Tissington
I'm still having problems trying to install sqldmo on a couple of client
machines
The files I'm installing are
sqldmo.dll
Resources\1033\sqldmo.rll
sqlresld.dll
sqlsvc.dll
Resources\1033\sqlsvc.rll
sqlunirl.dll
sqlwid.dll
sqlwoa.dll
w95scm.dll
When I attmempt to register it I get an error 80040154 back
I can install MSDE without any problems but I still can not register
sqldmo.dll
However I can install SQL Server client compnents without any problems.
Any idea what else the SQL Server Client install is doing or adding.
(this seems to be a problem specific to about 6 machines, other than that
the install works fine)
Thanks.
--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

[Mingqing Cheng [MSFT]]

Hi Michael Tissingtom,

I would appreciate your patience while I am looking into this issue. I will
post my response at soon as I have update for you.

Thank you for your patience and cooperation.


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
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,

From your descriptions, I understood that sqldmo's DLL could not be
registered on some of your machine. Have I understood you? If there is
anything I missed, please feel free to let me know:)

First of all, Make sure all files given below are in the WINNT\system32
directory
- Sqldmo.dll
- Sqldmo.rll
- Sqlsvc.dll
- Sqlsvc.rll
- Sqlwoa.dll
- Sqlresld.dll
- Sqlwid.dll
- W95scm.dll (for Win95 clients)

Secondly, SQLDMO.DLL is also dependent on ODBCBCP.DLL so that make sure
your you machine has ODBC installed. It's strongly recommand you upgrade to
MDAC 2.8 on those machine and then try to register SQLDMO again.

Thirdly, I suspect some of your dll files may be corrupted, which will lead
to failure of registering. Would you please find a new files of those
files(If you could not find, I would like to email them to you if you
needed, just tell me), and make another registeration?

Last but not the least, copying and registering SQLDMO components this way
to deploy SQLDMO applications is risky. Should consider using Visual
Studio Package Deployment Wizard (PDW) (see KB: Q258157 ) or SQL Server
Merge Modules (see BooksOnline)

Thank you for your patience and cooperation. 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 Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

[Michael Tissington]

Hello Mingqing,

I have already installed MDAC 2.8 and tried the things you sugest and it
does not work.

The install of the client components from the SQL Server install do install
correctly.

When I looked into how the Microsoft install was doing things I found that
it was NOT registering the dll sqldmo.dll, instead it was manually loading
the registry with the values.

Why is it doing this, maybe because of an obscure bug that I have come
across ?

Any way, when I copy this method, in other words do not register the dll,
but instead manually populate the registry then my application can run
correctly.

So why does registering the dll fail, but loading the registry manually
allow our application to work correctly.
--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

Post by Mingqing Cheng [MSFT]
Hi Michael,
From your descriptions, I understood that sqldmo's DLL could not be
registered on some of your machine. Have I understood you? If there is
anything I missed, please feel free to let me know:)
First of all, Make sure all files given below are in the WINNT\system32
directory
- Sqldmo.dll
- Sqldmo.rll
- Sqlsvc.dll
- Sqlsvc.rll
- Sqlwoa.dll
- Sqlresld.dll
- Sqlwid.dll
- W95scm.dll (for Win95 clients)
Secondly, SQLDMO.DLL is also dependent on ODBCBCP.DLL so that make sure
your you machine has ODBC installed. It's strongly recommand you upgrade to
MDAC 2.8 on those machine and then try to register SQLDMO again.
Thirdly, I suspect some of your dll files may be corrupted, which will lead
to failure of registering. Would you please find a new files of those
files(If you could not find, I would like to email them to you if you
needed, just tell me), and make another registeration?
Last but not the least, copying and registering SQLDMO components this way
to deploy SQLDMO applications is risky. Should consider using Visual
Studio Package Deployment Wizard (PDW) (see KB: Q258157 ) or SQL Server
Merge Modules (see BooksOnline)
Thank you for your patience and cooperation. 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 Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
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 Tissington,

Thanks for your prompt updates!

It's great to hear that you could make your application run successfully!

Unfortunately, I am not sure how you could monitor the setup up of SQL
Server Client Tools install and how do you populate the registry.

Anyway, I try to register sqldmo.dll on a 'clean' machine with only Windows
installed. It could be registered successfully. Could you provide a
scenario for us so that this situation could be reproduced?

Thank you for your patience and cooperation. 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 Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

[Michael Tissington]

Hi,

No I can not provide the details about the machines that this was causing a
problem on.

However, I got the idea to manually enter the registry values from the merge
modules for MSDE.
The SQLDMO merge module does NOT register sqldmo.dll. It imports the
registry values directly.
--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

Post by Mingqing Cheng [MSFT]
Hi Michael Tissington,
Thanks for your prompt updates!
It's great to hear that you could make your application run successfully!
Unfortunately, I am not sure how you could monitor the setup up of SQL
Server Client Tools install and how do you populate the registry.
Anyway, I try to register sqldmo.dll on a 'clean' machine with only Windows
installed. It could be registered successfully. Could you provide a
scenario for us so that this situation could be reproduced?
Thank you for your patience and cooperation. 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 Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!