Installing SQL-DMO
All required SQL-DMO components are installed as part of an instance of Microsoft® SQL Server™ server or client. SQL-DMO is implemented in a single dynamic-link library (DLL). You may develop SQL-DMO applications on either a client or a server. When using an OLE Automation controller as a development platform, such as Microsoft Visual Basic®, no additional files are required. Application development using C or C++ requires the SQL-DMO header files.
SQL-DMO sample applications, providing additional reference material for SQL-DMO application development, are included with SQL Server.
| Directory | File | Description |
|---|---|---|
| C:\Program Files\Microsoft SQL Server\80\Tools\Binn | Sqldmo.dll | DLL implementing SQL-DMO objects. |
| C:\Program Files\Microsoft SQL Server\80\Tools\Binn | Sqldmo80.hlp | SQL-DMO help file used within the development environment to provide context sensitive help about SQL-DMO objects, properties and methods. |
| C:\Program Files\Microsoft SQL Server\80\Tools\Binn\ Resources\xxxx |
Sqldmo.rll | Localized resource file. The resource directory varies based on the national language of the instance of SQL Server client or server. For example, the directory 1033 is a decimal representation of the language identifier 0X0409, indicating English, U.S. |
| C:\Program Files\Microsoft SQL Server\80\Tools\ Devtools\Include |
Sqldmo.h | C/C++ header file containing SQL-DMO member function prototypes, enumerated data types, and macros. |
| C:\Program Files\Microsoft SQL Server\80\Tools\ Devtools\Include |
Sqldmoid.h | C/C++ header file containing SQL-DMO interface and class identifiers. |
| \Program Files\Microsoft SQL Server\MSSQL\Install | Sqldmo.sql | Transact-SQL script implementing stored procedures that support SQL-DMO. Available on SQL Server server-instance only. |
| C:\Program Files\Microsoft SQL Server\80\Tools\ Devtools\Samples\Sqldmo |
ALL | Sample applications illustrating SQL-DMO use. |
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 - From any directory, execute:
C:\Program Files\Microsoft SQL Server \80\Tools\Binn\REGSVR32.EXE C:\Program Files\Microsoft SQL Server \80\Tools\Binn\resources\1033\SQLDMO.RLL