INF: Using SQL Server 6.5 DMO Against a SQL Server 6.0 Server

ID: Q151610

The information in this article applies to:

Microsoft SQL Server version 6.5

SUMMARY

You can use many of the features of the SQL Server 6.5 Database Management Objects (DMOs) against a SQL Server 6.0 server.

MORE INFORMATION

If you are writing an application that uses SQL Server DMOs and you want to use it against a SQL Server 6.0 server, you will need to install the following script:


   ..\MSSQL\INSTALL\SQLOLE65.SQL

Make sure you are on the SQL Server 6.0 computer when you perform the installation operations.

Use ISQL or ISQL/W to execute the SQLOLE65.SQL script on the SQL Server 6.0 server. This installs the stored procedures necessary to support the SQL Server 6.5 DMO calls. It is better to install these procedures when no other access to the SQL Server is taking place. This script is also compatible with the SQL Server 6.0 DMO.

When the script installation is complete, check the results for errors.

NOTE: You CANNOT run a SQL Server 6.5 DMO developed application directly on the SQL Server 6.0 server. Attempts to accomplish this will result in OLE "Interface Not Supported" errors. You will need to upgrade the computer to a SQL Server 6.5 server.

Additional query words: SoftLib


Keywords          : 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 25, 1999