Registering SQLDMO.dll

[Craig G]

how the hell do i get this to register?!?!?

my test pc is running XP & MDAC 2.8

but still it wont register SQLDMO.dll and is therefore preventing my
application from running

and i dont want to have to install SQL2000 Client on the test pc

 

[Guest]

SQLDMO.dll has a whole host of other dependencies, you would have to also install these.

I would check licensing issues, I don’t think you are allowed to distribute these dll’s with your application.

 

[Craig G]

licensing issues aint a problem as its an internal application

found this article about registering it, and still cant get it to
register!!! i only need to install 2 files on the client side

http://support.microsoft.com/default.aspx?scid=kb;en-us;248241

anybody else any idea's?

Cheers,
Craig

SQLDMO.dll has a whole host of other dependencies, you would have to also install these.

I would check licensing issues, I don't think you are allowed to

distribute these dll's with your application.

 

[Jeff Johnson [MVP: VB]]

licensing issues aint a problem as its an internal application

There are still client access licenses required, I believe. You know, if you
were to get audited or something....

 

[Craig G]

yeah licensing can be sorted if need be

but until i get this SQLDMO.dll registered everything is up sh*tcreek!!

 

[Craig G]

think i've just realised what im doing wrong,

i thought SQLDMO.dll & SQLDMO.rll are all that is required on the client
machine, the rest reside on the server.

ill let you know how i get on

I have read the article and it says that more than 2 files are required.
Sqldmo.dll
Sqldmo.rll
Sqlsvc.dll
Sqlsvc.rll
Sqlwoa.dll
Sqlresld.dll
Sqlwid.dll
W95scm.dll

Plus one or all of the following depending on the protocol used:
Named Pipes: Dbnmpntw.dll
Sockets: Dbmssocn.dll
Multi-Protocol: Dbmsrpcn.dll

We have a small program with our overall application that uses SQLDMO to

manage the database schema, I have tested this installing the above files
and it works fine.

There are licencing issuses, the company I work for states to our clients

that the application that manages the database schema can only be run on a
workstation with the correct licences. We have someone here who is really up
on licencing and he has confirmed that even using the dll's internally on a
none licenced machine is breaking the licence. Licencing is very
complicated, thats why we have someone dedicated to the task.

 

[Jeff Johnson [MVP: VB]]

licensing issues aint a problem as its an internal application

found this article about registering it, and still cant get it to
register!!! i only need to install 2 files on the client side

http://support.microsoft.com/default.aspx?scid=kb;en-us;248241

anybody else any idea's?

There should be a redist.txt file or something like it in your binn folder
under Microsoft SQL Server.