index.html

能够连接各种数据库的API

                    all release dynamic libraries already compiled. If for 
                    some reason you want to recompile SQLAPI++ sources or 
                    you want to compile debug and/or static versions you 
                    should use appropriate batch or makefiles located in the <STRONG>src</STRONG> 
            subdirectory 
                    of SQLAPI++ distributions.</P>
        <H3><A 
        name="Instructions for Compiling and Linking Applications with SQLAPI++"></A>Instructions for Compiling and 
                    Linking Applications with SQLAPI++</H3>
        <P>SQLAPI++ programs need the 
                    following components of the SQLAPI++ distribution:</P>
        <H4>Header files - Compile time</H4>
        <P>Programmers need to include the 
                    SQLAPI++ header files. Those with a command-line 
                    compiler will typically use options such as 
                    /I%SQLAPIDIR%\include or -I${SQLAPIDIR}/include. The 
                    header files are in the <STRONG>include</STRONG> subdirectory of SQLAPI++ 
                    distributions:<BR><STRONG>#include &lt;SQLAPI.h&gt; 
                    </STRONG>- main header, should be used whenever SQLAPI++ 
                    is used.<BR><STRONG>#include &lt;ora7API.h&gt;, &lt;oraAPI.h&gt; 
                    </STRONG>- Oracle 
            API, should be included if direct OCI calls are required<BR><STRONG>#include &lt;ssOleDbAPI.h&gt; - 
 
        </STRONG>SQLServer API, should be included if direct OLE DB 
                    calls are required<BR><STRONG>#include &lt;ss6API.h&gt; - 
 
        </STRONG>SQLServer API, should be 
            included if direct DB-Library calls are required<BR><STRONG>#include 
                    &lt;db2API.h&gt; </STRONG>- DB2 API, should be included 
                    if direct DB2 CLI calls are required<BR><STRONG>#include 
                    &lt;infAPI.h&gt; </STRONG>- Informix API, should be 
                    included if direct Informix CLI calls are required<BR><STRONG>#include &lt;ibAPI.h&gt; </STRONG>- Interbase API, 
                    should be included if direct InterBase API calls are 
                    required<BR><STRONG>#include &lt;sbAPI.h&gt; 
        </STRONG>- SQLBase, 
                    should be included if direct CAPI calls are required<BR><STRONG>#include &lt;sybAPI.h&gt; 
        </STRONG>- Sybase, should be 
            included if direct Open Client calls are required<BR><STRONG>#include &lt;myAPI.h&gt; 
        </STRONG>- MySQL, should be included if direct MySQL C API calls are 
            required<BR><STRONG>#include &lt;pgAPI.h&gt; 
        </STRONG>  - 
                    PostgreSQL, should be included if direct libpq calls are 
                    required<BR><STRONG>#include &lt;odbcAPI.h&gt; 
        </STRONG>- ODBC API, 
                    should be included if direct ODBC API calls are 
                    required</P>
        <H4>Static or dynamic libraries - 
                    Link time</H4>
      <P>Programmers need to link with 
                    static or dynamic libraries.<BR> 
           Those with a command-line compiler will typically use 
      options such as: /L%SQLAPIDIR%\lib\sqlapi.lib.</P>
      <P>The libraries are in the <STRONG>lib</STRONG> 
      subdirectory of SQLAPI++ distributions:</P>
        <P>    
        Win32:<BR><STRONG>sqlapi.lib </STRONG>- 
                    for linking with release version of dynamic library 
                    (MSVC)<BR><STRONG>sqlapid.lib </STRONG>- for linking with debug 
                    version of dynamic library (MSVC)<BR><STRONG>sqlapis.lib 
 
        </STRONG>- for linking with release version of static 
                    library (MSVC)<BR><STRONG>sqlapisd.lib </STRONG>- for 
                    linking with debug version of static library (MSVC)<BR><STRONG>sqlapib.lib </STRONG>- for linking with release 
                    version of dynamic library (Borland C++ compiler)<BR><STRONG>sqlapibd.lib </STRONG>- for linking with debug 
                    version of dynamic library (Borland C++ compiler)<BR><STRONG>sqlapibs.lib </STRONG>- for linking with release 
                    version of static library (Borland C++ compiler)<BR><STRONG>sqlapibsd.lib </STRONG>- for linking with debug 
                    version of static library (Borland C++ compiler)<BR><STRONG>sqlapibb.lib </STRONG>- for linking with release 
                    version of dynamic library (Borland C++ Builder)<BR><STRONG>sqlapibbd.lib </STRONG>- for linking with debug 
                    version of dynamic library (Borland C++ Builder)<BR><STRONG>sqlapibbs.lib </STRONG>- for linking with release 
                    version of static library (Borland C++ Builder)<BR><STRONG>sqlapibbsd.lib </STRONG>- for linking with debug 
                    version of static library (Borland C++ Builder)</P>
        <P>Linux/Unix:<BR><STRONG>libsqlapi.so 
                    </STRONG>- for linking with release version of dynamic 
                    library (GNU C and C++ project compiler)<BR><STRONG>libsqlapid.so 
                    </STRONG>- for linking with debug version of dynamic 
                    library (GNU C and C++ project compiler)<BR><STRONG>libsqlapi.a 
                    </STRONG>- for linking with release version of static 
                    library (GNU C and C++ project compiler)<BR><STRONG>libsqlapid.a 
                    </STRONG>- for linking with debug version of static 
                    library (GNU C and C++ project compiler)</P>
        <H4>Dynamic Link Libraries (DLLs) - 
                    Run time</H4>
        <P>Users of programs built with the 
                    dynamic SQLAPI++ libraries need these same dynamic 
                    libraries to run the programs. The DLLs are in the <STRONG>bin</STRONG> subdirectory 
                    of SQLAPI++ distributions:</P>
        <P>Win32:<BR><STRONG>sqlapi.dll</STRONG> - 
                    for programs linked with the release version of dynamic 
                    library (Microsoft VC, Borland compilers).<BR><STRONG>sqlapid.dll 
        </STRONG>- for programs linked with 
                    the debug version of dynamic library (Microsoft VC, 
                    Borland compilers).<BR><STRONG>sqlapi(Borland C++).dll </STRONG>- 
                    this is release DLL for Borland C++ compiler copied by 
                    installation program. If you are using Borland C++ 
                    compiler rename this DLL to sqlapi.dll.<BR><STRONG>sqlapi(Borland C++ 
                    Builder).dll </STRONG>- this is release DLL for Borland 
                    C++ Builder copied by installation program. If you are 
                    using Borland C++ Builder rename this DLL to 
                    sqlapi.dll.</P>
        <P>Linux/Unix:<BR><STRONG>libsqlapi.so</STRONG> 
                    - for programs linked with the release version of 
                    dynamic library (GNU C and C++ project compiler).<BR><STRONG>libsqlapid.so 
        </STRONG>- for programs linked with 
                    the debug version of dynamic library (GNU C and C++ 
                    project compiler).</P>
        <P>Dynamic libraries are made 
                    available to programs in places such as 
                    c:\windows\system on Windows platforms, in current 
                    folder or in the path. </P>
        <H3><A 
        name="SQLAPI++ Class Library Reference"></A>SQLAPI++ Class Library Reference </H3>
		<table frame=void CELLSPACING=5 width=165>
			<tr>
				<td>
				<A style="TEXT-DECORATION: none" href  ="Command.html" >
				<font size=2 face=sans-serif>
				SACommand</A></FONT> </td>
			</tr>
			<tr>
				<td>
				<A style="TEXT-DECORATION: none" href  ="Connection.html" >
				<font size=2 face=sans-serif>
				SAConnection</A></FONT> </td>
			</tr>
			<tr>
				<td>
				<A style="TEXT-DECORATION: none" href  ="Exception.html" >
				<font size=2 face=sans-serif>
				SAException</font></A> </td>
			</tr>
			<tr>
				<td>
				<A style="TEXT-DECORATION: none" href  ="Field.html" >
				<font size=2 face=sans-serif>
				SAField</A></FONT> </td>
			</tr>
			<tr>
				<td>
				<A style="TEXT-DECORATION: none" href  ="Param.html" >
				<font size=2 face=sans-serif>
				SAParam</A></FONT> </td>
			</tr>
			<tr>
				<td>
				<A style="TEXT-DECORATION: none" href  ="String.html" >
				<font size=2 face=sans-serif>
				SAString</A></FONT> </td>
			</tr>
			<tr>
				<td>
				<A style="TEXT-DECORATION: none" href  ="DateTime.html" >
				<font size=2 face=sans-serif>
				SADateTime</A></FONT> 
                </td>
			</tr>
		</table>
           
        <H3><A 
            name="SQL database servers specific information">SQL database 
            servers specific information</A>    </H3>
            <P align=left>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 developer has to know to use all 
            server's capabilities and avoid potential errors.</P>
            <P align=left>In the following topics we tried to collect all 
            <STRONG>specific</STRONG>
            information that 
            concerns working with each server supported by SQLAPI++ Library. 
            Full information about using SQLAPI++ see in <A href="../HowTo/index.html" >How To</A>
            and <A href="../OnLineDoc/index.html" >Online 
            Documentation</A>. 
            </P>
            
            <P align=left>Available       
             DBMS: </P>
            <UL>
                <LI><A href="../ServerSpecific/Oracle.html">Oracle</A>
                <LI><A href="../ServerSpecific/SQLServer.html">SQL Server</A>
                <LI><A href="../ServerSpecific/Sybase.html">Sybase</A>
                <LI><A href="../ServerSpecific/DB2.html">DB2</A>
                <LI><A href="../ServerSpecific/Informix.html">Informix</A>
                <LI><A href="../ServerSpecific/InterBase.html">InterBase</A>
                <LI><A href="../ServerSpecific/SQLBase.html">SQLBase</A>
                <LI><A href="../ServerSpecific/MySQL.html">MySQL</A>
                <LI><A 
                href="../ServerSpecific/PostgreSQL.html">PostgreSQL</A>
                <LI><A href="../ServerSpecific/ODBC.html">ODBC</A></LI>
            </UL>
        
        <HR>
             
        <P align=center><FONT size=2 
            >  
      Last  
      modified:&nbsp;11 August&nbsp;2004<BR>
            <A href="mailto:[e-mail]" >[e-mail]</A></FONT></P>
  </td></tr>
</table></FONT>
</body>
</html>