Home How To Online Documentation Support Download Order
 

 
Benefits
Examples
History
SQLAPI++ References
 

Quick download:

SQLAPI++ Win32

SQLAPI++ Linux

SQLAPI++ Sun SPARC Solaris







SQLAPI++ Library

SQLAPI++ is a C++ library for accessing multiple SQL databases (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL and ODBC, SQLite). It uses native APIs of target DBMS so applications developed with SQLAPI++ library run swiftly and efficiently. The product also provides a low-level interface that allows developers to access database-specific features. By encapsulating a vendor's API, SQLAPI++ library acts as middleware and delivers database portability. See details on supporting SQL database servers on different platforms:

Server Win32 Linux/Unix
Oracle Database Server Supported (OCI) Supported (OCI)
Microsoft SQL Server Supported (DB-Library, OLE DB) FreeTDS ODBC driver should be used
Sybase Supported (Open Client, ASE & ASA) Supported (Open Client, ASE & ASA)
DB2 Supported (DB2 CLI) Supported (DB2 CLI)
Informix Supported (Informix CLI) Supported (Informix CLI)
InterBase/Firebird Supported Supported
Centura (formerly Gupta) SQLBase Supported (CAPI) Supported (CAPI)
MySQL Supported (MySQL C API)  Supported (MySQL C API)
PostgreSQL Supported (libpq) Supported (libpq)
ODBC Supported Supported (iODBC, see www.iodbc.org)
SQLite
 Supported
 Supported

Currently SQLAPI++ library supports the following C/C++ compilers:

  • Microsoft Visual C++
  • Borland C++ Builder
  • GNU project C and C++ compiler

Why use SQLAPI++?

  • SQLAPI++ directly calls native API's of target DBMSs (unlike ADO which uses OLEDB and/or ODBC intermediate layer). That's why SQLAPI++ is the fastest way to manage you data.
  • No need (vs ADO) to install and configure OLEDB and/or ODBC drivers when developing and distributing your applications.
  • Low-level interface that allows developers to access database-specific features.
  • SQLAPI++ ships with all the sources.
  • Free lifetime support, bugs fixing and new version updates.

Examples

Steps

Step 1. Connecting to database (and error handling)
Step 2. Executing a simple SQL command
Step 3. Binding input parameters
Step 4. Executing a select query (and fetching result set)
Step 5. Binding LongBinary, LongChar, BLob and CLob data
Step 6. Fetching LongBinary, LongChar, BLob and CLob data
Step 7. Multithreading support and canceling queries

Advanced Examples

Using Oracle REF CURSORs
Using Oracle nested cursors
Fetching records in bulk

History

26 February 2008

Version 3.7.24 of SQLAPI++ library released.

New features:

  • MySQL: Connection options MYSQL_OPT_READ_TIMEOUT, MYSQL_OPT_WRITE_TIMEOUT and MYSQL_OPT_CONNECT_TIMEOUT added.
  • MySQL: Version 5.1 supported now.
  • Oracle: CLOB/BLOB truncation bug fixed.
  • Oracle: REFCURSOR memory leak problem fixed.
  • SQLite: Initial support for SQLite added.
  • ODBC: Added the special code for situations when the ODBC driver returns 0 bytes instead of SQL_NO_DATA (LongChar reading, thanks Frank Hilliger).
  • SQLServer: SQLOLEDB layer modified for Compact Edition 3.5.
  • SQLServer: Added Compact Edition specific options. Now CE layer is available at UNICODE version only.
  • DB2: Fixed the problem with column names (UNICODE version, thanks Adrian Studer).
  • General: Fixed the problem with the SANumeric rounding (thanks Mike Moening).
  • MySQL: Added SAInterval parameter processing (thanks Frank Hilliger).
12 October 2007

Version 3.7.23 of SQLAPI++ library released.

New features:

  • PostgreSQL: The error message includes the diagnostic trouble code now (thanks Helmut Ebersmann).
  • MySQL: Fixed bug with affected rows value (thanks Christoph Merten).
  • MySQL: Fixed bug with datetime/timestamp second part/fraction (thanks Helmut Ebersmann).
  • General: SACommand::ParseInputMarkers fixed for tabulator after parameter name (thanks Adrian Studer).
  • SQLServer: IssOleDbCursor::SetParameterInfo fixed for correct type name (thanks to Phillip at spectorsoft.com).
  • SQLServer: SQLOLEDB layer works with Compact/Mobile edition now (SQLAPI should be compiled with SA_UNICODE, thanks John Hague).
  • Sybase: New scheme of the client API libraries loading , SA_INCLUDES_SYBASE building parameter added (thanks Max Hales).
  • Sybase: CS_LOGIN_TIMEOUT and CS_TIMEOUT connection parameters added (thanks Beaty, Robert).
  • Oracle/General: Fixed issue with SANumeric/double conversion (thanks Adrian Studer).
  • Oracle: Fixed problem with CLOB and varying-width client-side character sets (UTF-8).
  • General: Build scripts updated. More samples are provided now.
25 June 2007

Version 3.7.22 of SQLAPI++ library released.

New features:

  • PostgreSQL: Fixed string escaping bug (buffer size too small, thanks combit.net).
  • SQL Server: Added statement preparation for each executing when option "ICommandPrepare" = "SetParameterInfo" used (thanks to Chris Hecker).
  • SQL Server: Fixed string parameters buffer size bug on x86_64/SQLOLEDB.
  • MySQL: Fixed access violation bug with fetching empty text field data (thanks Albert Perdon).
  • MySQL: Fixed bug with non-initialized statement handle (thanks Mario Lavalliere).
  • ODBC: The code modified to work correctly with long/blob fields under Linux and FreeTDS driver.
  • ODBC: SAConnection::isAlive() uses SQLGetConnectAttr/SQL_ATTR_CONNECTION_DEAD now.
  • SQL Server: Added SAConnection parameter "OLEDBProvider" (SQLOLEDB connection).
24 May 2007

Version 3.7.21 of SQLAPI++ library released.

New features:

  • Oracle: "APPNAME" SAConnection parameter added (OCI_ATTR_CLIENT_IDENTIFIER is used, thanks Frank Hilliger).
  • MySQL: Fixed bug with SAConnection::isAlive().
  • SQL Server: "ICommandPrepare" SACommand parameter value "SetParameterInfo" added (fixes KB235053).
  • MySQL: "UseStatement" SACommand parameter added (SQLAPI++ can use MySQL statement API now).
  • MySQL: Fixed long character type support with UNICODE.
  • Oracle: Fixed CLOB type support with UNICODE.
  • ODBC: Fixed access violation bug at IodbcConnection::Check (UNICODE, thanks Jay Sridhar).
  • DB2: Fixed possible access violation bug at Idb2Connection::Check (UNICODE).
30 March 2007

Version 3.7.20 of SQLAPI++ library released.

New features:

  • Sybase: Version 15.x support for Linux/UNIX (.so names changed - thanks Ronan O'Sullivan).
  • Oracle: Crash fixed with the OCIDateTime descriptor freeing.
  • DB2: Unicode support improved.
  • General: Added common SAConnection option: "APPNAME", "WSID" (they are supported for SQL Server and Sybase at the moment).
  • SQL Server (OLDEDB): Added SAConnection options SSPROP_INIT_FILENAME, SSPROP_INIT_ENCRYPT, SSPROP_INIT_WSID.
  • PostgreSQL: Added using of the PQescape* functions if they are available.
  • DB2: SA_dtString procedure parameter type is used for the LONG VARCHAR database type.
  • MySQL: Added support for multiple result set.
  • SQL Server (OLDEDB): x86_64 fixes.
  • DB2: All diagnostic messages are combined into SAException error text now.
  • Sybase: CS_HAFAILOVER connection parameter added.
  • General: Fixed a SADateTime::TmFromDate problem with the rounding.
  • DB2: XML type support added.
  • DB2: Fixed x86_64 support.
28 December 2006

Version 3.7.19 of SQLAPI++ library released.

New features:

  • Oracle: Added procedure/function support for Oracle PL/SQL BOOLEAN type.
  • Oracle: Support for BINARY_FLOAT and BINARY_DOUBLE types.
  • Oracle: Memory leak fixed with SYS_REFCURSOR & TIMESTAMP/BLOB/CLOB fields.
  • General: Added bool& SAGlobals::UnloadAPI() - prevent from DBMS API unloading.
  • General: SADateTime::SADateTime(double dt) - round the fraction result to microseconds.
  • General: Added SAInterval class for time intervals (experimental, only MySQL support for now).
  • MySQL: Support for multi-result statements.
  • MySQL: Set by default connection flags CLIENT_MULTI_STATEMENTS and CLIENT_MULTI_RESULTS.
  • SQLBase: Fixed access violation at sqldes() C API function with SQLBase version 10.
  • MySQL: Added support for the 'bit' type.
  • PostgreSQL: Fixed problem with bytea/text on AIX 64-bit (seems common 64-bit platform problem).
  • Sybase: Fixed MinGW version.
  • ODBC: Windows x64 fixes. Should work now.
  • Oracle: Fixed bug with DateTime parameters and an execution of prepared statements.
27 September 2006

Version 3.7.18 of SQLAPI++ library released.

New features:

  • General: Added SACommand::operator << (unsigned short Value) and SACommand::operator << (unsigned long Value)
  • MySQL: Added "CharacterSet" SAConnection option.
  • Oracle: Fixed bug with SADateTime to Oracle OCIDateTime conversion.
  • SQLServer: Fixed bug when it was impossible to fetch several result sets with single query.
  • MySQL: Added mysql_thread_init() and mysql_thread_end() API functions.
  • MySQL: Added mysql_server_end() call before MySQL client library is released.
16 August 2006

Version 3.7.17 of SQLAPI++ library released.

New features:

  • General: AIX, HP-UX and MacOS X support improved.
  • SQLServer: Added SSPROP_INIT_MARSCONNECTION connection (OLEDB) option.
  • PostgreSQL: Server side cursor implemented for 'SELECT ...' statements.
  • InterBase: Modified to start transaction only when query executed (thanks Fabrice Aeschbacher).
  • General: New SQLAPI++ data types added: SA_dtUShort and SA_dtULong.
  • General: Added SAString methods SAString::MakeUpper(), SAString::MakeLower().
  • General: Experimental 'scrollable cursor' functionality implemented (PostgreSQL,MSSQL,ODBC thanks combit.net).
  • General: Fixed SACommand::ParseInputMarkers for '=' parameter name delimiter.
  • Oracle: Fixed memory leaks and troubles with BLOB and TIMESTAMP descriptors.
  • Oracle: UNICODE version uses UCS2 client character set.
  • Oracle: Fixed bug at IoraConnection::CnvtNumericToInternal with numbers like [-]0.001
  • Oracle: Fixed memory leak with temporary BLOBs (thanks Frank Hilliger).
  • General: Experimental methods SAConnection::Destroy() added (to destroy broken connection).
  • General: Experimental method SAConnection::isAlive() added (to check if a remote database is alive).
  • MySQL: mysql_ping was removed from SAConnection::IsConnected().
  • ODBC: Fixed column size and precision for SADateTime input parameters.
  • Sybase: Fixed "CS_HOSTNAME" connection option (thanks Ulrich Gievers).
  • Sybase: Bug fixed with INTEGER-s on x86-64.
  • MySQL: Bug fixed long text/binary procedure parameters.
  • Oracle: New SAConnection "UseTimeStamp" option (controls if SQLAPI should use Oracle TIMESTAMP functions).
  • Oracle: Fixed bug with procedure datetime parameters.
  • DB2: Fixed bug with INTEGER-s on x86-64.
  • ODBC: Fixed bug with SAException::ErrMsg() at UNICODE configuration. UNICODE support improved.
  • General: Fixed bug at SAString::FormatV(...) on Linux/UNIX (thanks Michael Teske).
  • SQLServer: DB-Library client included into MinGW build.
  • MySQL: Fixed the procedure parameters parsing code.

See Full History...

Last modified: 26 February 2007
webmaster@sqlapi.com