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

 Last reviewed: October 30, 1997
Article 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
Version : 6.5
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.