Monday, 18 February 2013

Install SQL-DMO for Clients

SQL-DMO (Data Management Objects) is not the best choice, but has regardless been adopted in one of our little applications.

Previously, it has always (to my knowledge) installed perfectly fine on many client machines. However, after having taken over the project (for some other improvements) I come to find myself having major deployment problems with the SQLDMO.dll file. The file is used in a setup Custom Action to allow the user to configure database details on install.

Any attempts to register this file fail (via regsvr32). There are various answers to how to get it registered; I tried a few and none worked.

  • LoadLibrary (snip) failed - The specified module could not be found.

To cut a long story short, you need to install "Microsoft SQL Server 2005 Backward Compatibility Components" (which contains SQL-DMO):

Unfortunately, there are no standalone redistributables just for SQL-DMO.  However, you can specify to only install the DMO parts in the installer, but this is down to the install.

To register the SQL-DMO components on a client computer
  • From C:\Program Files\Microsoft SQL Server \80\Tools\Binn\Resources\<language> directory, execute:
\Program Files\Microsoft SQL Server \80\Tools\Binn\REGSVR32 SQLDMO.DLL

No comments:

Post a Comment