Server Specific Guide

SQL Server

SQLAPI++ allows to work with a number of SQL database servers. It provides common mechanisms to access database, and as a general rule they work for any database server. But each server has some specific features which a developer has to know in order to leverage server's unique features and avoid potential errors.

Working with SQL Server using SQLAPI++ Library depends on choosing an API. SQLAPI++ Library supports the following interfaces to access SQL Server :

Starting from version 3.3.1 SQLAPI++ Library uses OLE DB as default API when working with SQL Server. If for some reason you want to use SQLNCLI or DB-Library, you should set "UseAPI" connection option before specifying SQL Server client or connecting to database:

SAConnection con;
con.setOption( "UseAPI" ) = "DB-Library";
con.setClient( SA_SQLServer_Client );
con.Connect(...);

For more connection details see SQL Server (OLE DB), SQL Server (ODBC) and SQL Server (DB-Library) specific information.

It's preferably to use OLE DB because ODBC and DB-Library has some limitations. Furthermore, DB-Library interface is unchanging, it doesn't support new server features.

Full information about using SQLAPI++ see in How To and Online Documentation .