Programming Open Data Services

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:

Extended Stored Procedures

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.

Gateway Applications

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.

See Also

Backward Compatibility Details (Level 3)


(c) 1988-98 Microsoft Corporation. All Rights Reserved.