Microsoft KB Archive/151610

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

Article ID: 151610

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q151610



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: KB151610

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.