INF: Using SQL Server 6.5 DMO 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.