The SQL-DMO is a part of the Distributed Management Framework that Microsoft provides for SQL Server. This framework is three-tiered consisting of SQL Server, SQL-DMO, and SQL Executive. The SQL-DMO is the middle level that provides the interface to manage features of SQL Server. The SQL-DMO has its own hierarchy consisting of the application, SQL Server, database, and table objects. The important point to remember is that each level consists of objects related to the level. For example, the database level consists of stored procedure and table objects.
Files needed
Microsoft introduced SQL-DMO in SQL Server version 6.0. A good rule to observe is to use the proper version of SQL-DMO with the proper SQL Server. These DLL's are located within the BINN directory of your SQL Server.
- SQL Server 6.0
- SQLOLE32.DLL
- SQL Server 6.5
- SQLOLE65.DLL
- SQL Server 7.0 & SQL Server 2000
- SQLDMO.DLL - The names are the same, but they really are different. You can not access SQL Server 2000 using the SQL 7 SQL-DMO, although you can do vice-versa.
- MSDE
- SQLDMO.DLL - Both SQL 7 and SQL Server 2000 should work.
(Save your self some stress and just load the client tools for the given SQL Server on your web server!)
Comments