📄 index.html
字号:
<html>
<head>
<meta name="KEYWORDS" content="
library, C, C++,
Oracle, SQL Server, SQLServer, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, Postgre, ODBC,
client, database, programming, development, software,
Win32, Windows, Linux, Unix, Solaris,
Microsoft, Borland, Centura, Gupta, IBM">
<meta name="DESCRIPTION" content="SQLAPI++ is C++ library for accessing SQL databases (Oracle, SQL Server, Sybase, DB2, InterBase, SQLBase, Informix, MySQL, Postgre, ODBC).
It is easy to use and very efficient.">
<title>SQLAPI++ - C++ library for accessing SQL databases</title>
</head>
<body bgcolor="#ffffff" BACKGROUND="./images/bg.gif" text="#000000"><!--class="GlbHdr"-->
<table WIDTH="600" height="40" frame="hsides" BORDER="2" BORDERCOLOR="#004fcd" align="right" cellpadding="0" cellspacing="2" id="TABLE1">
<tr><!--class="GlbActive"-->
<td width="70" bgcolor="#00bb00" bordercolor="black" align="middle">
<A style="TEXT-DECORATION: none" href="./index.html" >
<font color="white" size="3" face="sans-serif">
<b>Home</b></font></A></td>
<td width="70" bgcolor="#000094" bordercolor="black" align="middle">
<A style="TEXT-DECORATION: none" href="./HowTo/index.html" >
<font color="white" size="3" face="sans-serif">
<b>How To</b></font></A></td><!--class="GlbDefault"-->
<td width="70" bgcolor="#000094" bordercolor="black" align="middle">
<A style="TEXT-DECORATION: none" href="./OnLineDoc/index.html" >
<font color="white" size="3" face="sans-serif">
<b>Online Documentation</b></font></A></td><!--class="GlbDefault"-->
<td width="70" bgcolor="#000094" bordercolor="black" align="middle">
<A style="TEXT-DECORATION: none" href="./Support/index.html" >
<font color="white" size="3" face="sans-serif">
<b>Support</b></font></A></td>
<td width="70" bgcolor="#000094" bordercolor="black" align="middle">
<A style="TEXT-DECORATION: none" href="./Download/index.html" >
<font color="white" size="3" face="sans-serif">
<b>Download</b></font></A></td>
<td width="70" bgcolor="#000094" bordercolor="black" align="middle">
<A style="TEXT-DECORATION: none" href="./Order/index.html" >
<font color="white" size="3" face="sans-serif">
<b>Order</b></font></A></td>
</tr>
</table>
<p> </p>
<table width="100%">
<tr>
<td valign="top" width="165"><!--class="LeftMenu"-->
<table frame="void" CELLSPACING="5" width="165">
<tr>
<td><p>
<table cellSpacing="5" frame="void" width="165">
<tr>
<td>
<p>
</p>
</td></tr>
<tr>
<td><img align="middle" height="12" src="./images/green.gif" width="12"><A style="TEXT-DECORATION: none" href="#Benefits" ><font color="white" face="sans-serif" size="2">Benefits</font></A></td></tr>
<tr>
<td><img align="middle" height="12" src="./images/green.gif" width="12"><A style="TEXT-DECORATION: none" href="#Examples" ><font color="white" face="sans-serif" size="2">Examples</font></A></td></tr>
<tr>
<td><img align="middle" height="12" src="./images/green.gif" width="12"><A style="TEXT-DECORATION: none" href="#History" ><font color="white" face="sans-serif" size="2">History</font></A> </td></tr>
<tr>
<td><img align="middle" height="12" src="./images/green.gif" width="12"><A style="TEXT-DECORATION: none" href="references.html" ><font color="white" face="sans-serif" size="2">SQLAPI++ References</font></A> </td></tr>
<tr>
<td><font color="white" face="sans-serif" size="2"> </font></td></tr></table><br></p>
<p><font color="white"><strong>Quick
download:</strong>
</font></p>
<p><a style="TEXT-DECORATION: none" href="http://www.sqlapi.com/Download/sqlapi.exe">
<font color="white" face="sans-serif" size="2"><u>SQLAPI++ Win32</u>
</font></a> </p>
<p><a style="TEXT-DECORATION: none" href="http://www.sqlapi.com/Download/sqlapi.tar.gz">
<font color="white" face="sans-serif" size="2"><u>SQLAPI++ Linux</u>
</font></a> </p>
<p><a style="TEXT-DECORATION: none" href="http://www.sqlapi.com/Download/sqlapi.tar.Z">
<font color="white" face="sans-serif" size="2"><u>SQLAPI++ Sun SPARC Solaris</u>
</font></a> </p></td>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</td><!--empty column-->
<td width="20">
<p> </p>
</td><!--Content-->
<td valign="top" align="left">
<center>
<h1> SQLAPI++ Library</h1>
</center>
<p>SQLAPI++ is a C++ library for accessing multiple SQL
databases (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL and
ODBC). 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:</p>
<p>
<table border="1" cellPadding="1" cellSpacing="1">
<tr bgColor="blue">
<td><strong><font color="white" style="BACKGROUND-COLOR: #0000ff">Server</font></strong></td>
<td><strong><font color="white" style="BACKGROUND-COLOR: #0000ff">Win32</font></strong></td>
<td><font color="white" style="BACKGROUND-COLOR: #0000ff"><strong>Linux/Unix</strong></font></td>
</tr>
<tr>
<td>Oracle Database Server </td>
<td> Supported (OCI)</td>
<td>Supported (OCI)</td>
</tr>
<tr>
<td>Microsoft SQL Server</td>
<td>Supported (DB-Library, OLE DB)</td>
<td> </td>
</tr>
<tr>
<td>Sybase</td>
<td>Supported (Open Client, ASE &
ASA)</td>
<td>Supported (Open Client, ASE &
ASA)</td>
</tr>
<tr>
<td>DB2</td>
<td>Supported (DB2 CLI)</td>
<td>Supported (DB2 CLI)</td>
</tr>
<tr>
<td>Informix</td>
<td>Supported (Informix CLI)</td>
<td>Supported (Informix CLI)</td>
</tr>
<tr>
<td>InterBase</td>
<td>Supported</td>
<td>Supported</td>
</tr>
<tr>
<td>Centura (formerly Gupta) SQLBase</td>
<td>Supported (CAPI)</td>
<td> </td>
</tr>
<tr>
<td>MySQL</td>
<td>Supported (MySQL C API) </td>
<td>Supported (MySQL C API)</td>
</tr>
<tr>
<td>PostgreSQL</td>
<td>Supported (libpq)</td>
<td>Supported (libpq)</td>
</tr>
<tr>
<td>ODBC</td>
<td>Supported</td>
<td>Supported (iODBC, see <a href="http://www.iodbc.org">www.iodbc.org</a>)</td>
</tr>
</table>
</p>
<p>Currently SQLAPI++ library supports the
following C/C++ compilers:</p>
<ul>
<li> Microsoft Visual
C++
<li>Borland C++
<li>Borland C++ Builder
<li>GNU project C and C++ compiler</li>
</ul>
<h2><a name="Benefits"></a>Why
use SQLAPI++?</h2>
<ul>
<li>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.
<li>No need (vs ADO) to install and
configure OLEDB and/or ODBC drivers when developing and
distributing your applications.
<li>Low-level interface that allows
developers to access database-specific features.
<li>SQLAPI++ ships with all the sources.
<li>Free lifetime support, bugs fixing and
new version updates.</li>
</ul>
<h2><a name="Examples"></a> Examples</h2>
<h3>Steps</h3>
<p><A href="./Examples/step1.cpp">Step 1</A>.
Connecting to database (and error handling)<br>
<A href="./Examples/step2.cpp">Step 2</A>.
Executing a simple SQL command<br>
<A href="./Examples/step3.cpp">Step 3</A>.
Binding input parameters<br>
<A href="./Examples/step4.cpp">Step 4.</A>
Executing a select query (and fetching result set)<br>
<A href="./Examples/step5.cpp">Step 5.</A>
Binding LongBinary, LongChar, BLob and CLob data<br>
<A href="./Examples/step6.cpp">Step 6.</A>
Fetching LongBinary, LongChar, BLob and CLob data<br>
<A href="./Examples/step7.cpp">Step 7.</A>
Multithreading support and cancelling queries<br>
</p>
<h3>Advanced Examples</h3>
<p><A href="./Examples/refcursors.cpp">Using Oracle REF CURSORs</A><br>
<A href="./Examples/nestedcursors.cpp">Using Oracle nested cursors</A><br><A href="./Examples/bulk_fetch.cpp">Fetching records in bulk</A><br>
</p>
<h2><a name="History"></a>History</h2>
<table border="0" cellPadding="1" cellSpacing="1" style="WIDTH: 100%" width="100%">
<tr bgColor="blue">
<td><font color="#ffffff"><strong>11 August
2004</strong></font></td></tr>
<tr>
<td>
<p>Version 3.7.11 of SQLAPI++ library released.</p>
<p>New features:</p>
<ul>
<li>ODBC: connection-level option added to control ODBC's connection pooling.
<li>MySQL: added support for MySQL clients version 4.1 and higher.
<li>MySQL: connection-level options added to control client_flag parameter when connecting to MySQL.
The following options added: CLIENT_COMPRESS, CLIENT_FOUND_ROWS,
CLIENT_IGNORE_SPACE, CLIENT_INTERACTIVE, CLIENT_LOCAL_FILES,
CLIENT_NO_SCHEMA, CLIENT_ODBC
<li>SQL Server: command-level option added: DBPROP_REMOVEDELETED.
<li>Sybase: command-level option added: ct_cursor.
<li>General: small memory leak fixed.
</ul>
</td>
</tr>
</table>
<table border="0" cellPadding="1" cellSpacing="1" style="WIDTH: 100%" width="100%">
<tr bgColor="blue">
<td><font color="#ffffff"><strong>
10 January
2004</strong></font></td></tr>
<tr>
<td>
<p>Version 3.7.10 of SQLAPI++ library released.</p>
<p>New features:</p>
<ul>
<li>ODBC: bulk fetching support improved as a
work-around for some non-compliant drivers.
<li>Oracle: added support for new date/times
types in Oracle 9i.
<li>Oracle: added read support for interval
types. They are defaulted to strings.
<li>SQL Server: added read support for fields
of type VARIANT. They are defaulted to strings.
<li>SAString:Format(): bug fixed with "I64"
option implementation on Windows platform.
<LI>SAString::Format(): small change to
better support variable argument list on some picky UNIX platforms.</LI>
</ul>
</td>
</tr>
</table>
<table border="0" cellPadding="1" cellSpacing="1" style="WIDTH: 100%" width="100%">
<tr bgColor="blue">
<td><font color="#ffffff"><strong>
13 July
2003</strong></font></td></tr>
<tr>
<td>
<p>Version 3.7.9 of SQLAPI++ library released.</p>
<p>New features:</p>
<ul>
<li>SQL Server: new command related option ("SSPROP_INIT_APPNAME") added.
For more information see <A href="./ServerSpecific/SQLServer_OleDb.html#Connection and command options">
SQL Server (OLE DB) - Connection and command options</A>.
<LI>Oracle: small memory leak fixed with Oracle 9i client.</LI>
</ul>
</td>
</tr></table>
<table border="0" cellPadding="1" cellSpacing="1" style="WIDTH: 100%" width="100%">
<tr bgColor="blue">
<td><font color="#ffffff"><strong>
2 March
2003</strong></font></td></tr>
<tr>
<td>
<p>Version 3.7.8 of SQLAPI++ library released.</p>
<p>New features:</p>
<ul>
<li> PostgreSQL: support
for TIMESTAMPTZOID type added.
<LI> Oracle: bulk fetch implementation improved for columns of
type NUMBER.</LI>
</ul>
</td>
</tr></table>
<table border="0" cellPadding="1" cellSpacing="1" style="WIDTH: 100%" width="100%">
<tr bgColor="blue">
<td><font color="#ffffff"><strong>
1 December
2002</strong></font></td></tr>
<tr>
<td>
<p>Version 3.7.7 of SQLAPI++ library released.</p>
<p>New features:</p>
<ul>
<li>SQL Server (OLE DB): bug fixed when
reading large NTEXT columns.
<LI>SQLBase: bug fixed when using Receive Long String variables in
stored procedures.</LI>
</ul>
</td>
</tr></table>
<table border="0" cellPadding="1" cellSpacing="1" style="WIDTH: 100%" width="100%">
<tr bgColor="blue">
<td><font color="#ffffff"><strong>
21 September 2002</strong></font></td></tr>
<tr>
<td>
<p>Version 3.7.6 of SQLAPI++ library released.</p>
<p>New features:</p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -