Home How To Online Documentation Support Download Order

 

 

 
SACommand
SAConnection
SAException
SAField
SAParam
SAString
SADateTime
SANumeric
Enums and Typedefs

  

Usage

Class Members

Examples

SAConnection::setClient

void setClient( SAClient_t eSAClient );
throw (SAException);

Assigns an DBMS client for the connection.

Parameters

eSAClient.    One of the following values from SAClient_t enum:

  • SA_Oracle_Client    Oracle client.
  • SA_SQLServer_Client    SQL Server client.
  • SA_InterBase_Client    InterBase client.
  • SA_SQLBase_Client    SQLBase client.
  • SA_ODBC_Client    ODBC client.
  • SA_DB2_Client    DB2 client.
  • SA_Informix_Client    Informix client.
  • SA_Sybase_Client    Sybase client.
  • SA_MySQL_Client    MySQL client.
  • SA_PostgreSQL_Client    PostgreSQL client.
  • SA_SQLite_Client    SQLite client.

Remarks

You can set a client in Connect method, in this case you don't need to use setClient method. The main destination of this method is to connect to a server with no connection to a database (for example, to check a client availability and version). But if you are calling Connect method with no specified client you have to use setClient method before.

If you are calling setClient method when the connection is set to another client the previous connection will be disconnected and new client will be set.

Server specific notes

Oracle

The SQLAPI++ Library requires OCI version 7.3 or higher. The Library tries to load OCI8 first. If it fails it tries to load OCI7.

SQL Server (OLE DB)

Starting from version 3.3.1 SQLAPI++ Library uses OLE DB as default API when working with SQL Server.
The SQLAPI++ Library requires SQL Server OLE DB version 2.5 or higher.

SQL Server (DB-Library)

Starting from version 3.3.1 SQLAPI++ Library uses OLE DB as default API when working with SQL Server. If you want to use DB-Library, you should set "UseAPI" connection option before specifying SQL Server client or connecting to database.
The SQLAPI++ Library requires DB-Library version 6.x or higher.

Sybase

The SQLAPI++ Library requires Open Client version 10.0 or higher.

DB2

The SQLAPI++ Library requires DB2 CLI version 6.x or higher.

Informix

The SQLAPI++ Library requires Informix CLI version 2.x or higher.

InterBase

The SQLAPI++ Library requires client API version 5.x or higher. All Firebird versions are supported also.

SQLBase

The SQLAPI++ Library requires CAPI version 6.x or higher.

MySQL

The SQLAPI++ Library requires MySQL C API version 3.23.x or higher.

PostgreSQL

The SQLAPI++ Library requires libpq version 7.1.x or higher.

ODBC

The SQLAPI++ Library requires ODBC version 3.x or higher.
SQLite The SQLAPI++ Library requires SQLite version 3.x or higher.

See also

Connect, setOption

SAClient_t

Error handling

Problems and Questions

If you haven't found the answer to your questions or have some problems on using the Library, please, send e-mail to howto@sqlapi.com.