Getting Started with SQL-DMO

SQL-DMO (SQL Server 2000)

SQL-DMO Syntax Conventions

SQL-DMO typographical conventions are based on those used in Microsoft® Visual Basic® reference materials.

Convention	Used for
UPPERCASE	Transact-SQL statements, macro names, and terms used at the operating system level.
monospace	Sample command lines and program code.
italic	Information that the user or the application must provide.
bold	SQL-DMO objects; object events, methods or properties; data types; and other syntax that must be typed exactly as shown.

Note  Automation allows SQL-DMO to expose object properties, methods, events, and constants through intelligent and easy-to-use automation controllers, simplifying the development task.

When using an automation controller, such as Visual Basic, assistance built into the controller exposes SQL-DMO object properties, methods, and events as defined, and prompts for required or optional parameters as part of the development process. When using C or C++, every object property and method appears as an object member function, and the distinction disappears.

The SQL-DMO documentation is directed at the user of an automation controller. Properties are documented as properties, not member functions. Prototypes for SQL-DMO object member functions are included in each topic for the C or C++ developer.

System Requirements for SQL-DMO

SQL-DMO (SQL Server 2000)

System Requirements for SQL-DMO

SQL-DMO uses the Microsoft® SQL Server™ ODBC driver to connect to and communicate with instances of SQL Server. Stored procedures supporting SQL-DMO are installed on each instance of SQL Server.

SQL-DMO clients require one of these operating systems:

• Microsoft Windows NT® version 4.0 (Service Pack 5 or later).
  
  
• Microsoft Windows® 98 or Microsoft Windows® 95.

  Or

• Microsoft Windows® 2000.

SQL-DMO clients require SQL Server ODBC Driver, version 3.80 or later, which ships with SQL Server 2000. The client network library must be properly configured.

SQL-DMO locates instances of SQL Server using the SQL Server instance name. SQL-DMO does not use ODBC data source definitions for connection, and you need not use the ODBC Administrator to create data source definitions for servers administered by SQL-DMO applications.

Stored procedures that support SQL-DMO are created as part of an instance of SQL Server 2000. The Transact-SQL script Sqldmo.sql is shipped with SQL Server 2000 and can be used to reinstall the required stored procedures if necessary.

Installing SQL-DMO

SQL-DMO (SQL Server 2000)

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