Microsoft Open Data Services provides a server-based application programming interface (API) for extending Microsoft® SQL Server™ functionality. The API consists of C and C++ functions and macros used to build applications in the following categories:
Packaged as dynamic-link libraries (DLLs), extended stored procedures provide a way to extend SQL Server functionality through functions developed by using C/C++, the Open Data Services API, and the Microsoft Win32® API. These functions can send result sets and output parameters back to the client from a variety of external data sources.
In the past, Open Data Services was used to write server applications, such as gateways to non-SQL Server database environments. With the emergence of newer and more powerful technologies, such as Windows NT Component Services and SQL Server distributed queries, the need for Open Data Services gateway applications has largely been replaced. It is strongly recommended that you do not use Open Data Services to write any new gateway applications for SQL Server.
To use the Opends60.dll shipped with SQL Server version 7.0, the existing gateway application needs to be recompiled with the Open Data Services header (srv.h) and library (opends60.lib) files. Using Opends60.dll from SQL Server 7.0 with a gateway application that was compiled and linked with the SQL Server Open Data Services 6.x headers and libraries is not supported.
Backward Compatibility Details (Level 3)