Export (0) Print
Expand All
0 out of 5 rated this helpful - Rate this topic

Installing SQL-DMO

SQL Server 2000

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\
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\
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\
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\
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

See Also

Overview of Installing SQL Server 2000

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.