📄 sqlserver.html
字号:
<html><head><meta name="KEYWORDS" content=" library, C++, Oracle, SQLServer, DB2, Sybase, Informix, InterBase, SQLBase, ODBC,
SQL, server, 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, SQLServer, Sybase, DB2, InterBase, SQLBase, Informix, ODBC).
It uses native APIs, provides low-level access to database-specific features."><title>SQLAPI++ Library - Server Specific Guide - SQL Server</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="GlbDefault"-->
<td width=70 bgcolor=#000094 bordercolor=black align=middle>
<A href="../index.html" style="TEXT-DECORATION: none" >
<font color=white size=3 face=sans-serif>
<b>Home</b></font></A></td></TD>
<td width=70 bgcolor=#000094 bordercolor=black align=middle>
<A href="../HowTo/index.html" style="TEXT-DECORATION: none" >
<font color=white size=3
face=sans-serif>
<b>How To</b></font></A></td><!--class="GlbActive"-->
<td width=70 bgcolor=#00bb00 bordercolor=black align=middle>
<A href="../OnLineDoc/index.html" style="TEXT-DECORATION: none" >
<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 href="../Support/index.html" style="TEXT-DECORATION: none" >
<font color=white size=3
face=sans-serif>
<b>Support</b></font></A></td>
<td width=70 bgcolor=#000094 bordercolor=black align=middle>
<A href="../Download/index.html" style="TEXT-DECORATION: none" >
<font color=white size=3
face=sans-serif>
<b>Download</b></font></A></td>
<td width=70 bgcolor=#000094 bordercolor=black align=middle>
<A href="../Order/index.html" style="TEXT-DECORATION: none" >
<font color=white size=3
face=sans-serif>
<b>Order</b></font></A></td>
</tr>
</table>
<p> </p>
<p> </p>
<table width="100%">
<tr>
<td valign=top width=165><!--class="LeftMenu"-->
<table frame=void CELLSPACING=5 width=165>
<tr>
<td><p><br></p></td>
</tr>
<tr>
<td><img align=middle src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="../OnLineDoc/Command.html" style ="TEXT-DECORATION: none" >
<font color=white size=2 face=sans-serif>
SACommand</A> </FONT> </td>
</tr>
<tr>
<td><img align=middle src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="../OnLineDoc/Connection.html" style ="TEXT-DECORATION: none" >
<font color=white size=2 face=sans-serif>
SAConnection</A> </FONT> </td>
</tr>
<tr>
<td><img align=middle src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="../OnLineDoc/Exception.html" style ="TEXT-DECORATION: none" >
<font color=white size=2 face=sans-serif>
SAException</font></A> </td>
</tr>
<tr>
<td><img align=middle src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="../OnLineDoc/Field.html" style ="TEXT-DECORATION: none" >
<font color=white size=2 face=sans-serif>
SAField</A> </FONT> </td>
</tr>
<tr>
<td><img align=middle src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="../OnLineDoc/Param.html" style ="TEXT-DECORATION: none" >
<font color=white size=2 face=sans-serif>
SAParam</A> </FONT> </td>
</tr>
<tr><td><hr></td></tr>
<tr>
<td><img align=middle src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="../OnLineDoc/String.html" style ="TEXT-DECORATION: none" >
<font color=white size=2 face=sans-serif>
SAString</A> </FONT> </td>
</tr>
<tr>
<td><img align=middle src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="../OnLineDoc/DateTime.html" style ="TEXT-DECORATION: none" >
<font color=white size=2 face=sans-serif>
SADateTime</A> </FONT> </td>
</tr>
</table>
</td><!--empty column-->
<td width=20>
<p> </p>
</td><!--Content-->
<td valign=top align=left>
<center>
<H2><A href="index.html">Server Specific Guide</A></H2>
<h1>SQL Server</h1>
<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 capability and avoid potential errors.</P>
<P align=left>
Working with <STRONG>SQL Server</STRONG> using SQLAPI++ Library depends on
choosing an API. SQLAPI++ Library supports the following interfaces
to access <STRONG>SQL Server</STRONG>
:
</P>
<DIV align=left>
<UL>
<LI><A href="SQLServer_OleDb.html">OLE DB</A></LI>
<LI><A
href="SQLServer_DbLibrary.html">DB-Library</A></LI></UL></DIV>
<P align=left>Starting from version 3.3.1
SQLAPI++ Library uses <U>OLE DB as default API</U> when working with
<STRONG>SQL Server</STRONG>. If for some reason you want to use
DB-Library, you should set "UseAPI" connection option
before specifying SQL Server client or connecting to
database:
</P>
<P align=left><FONT face=System>SAConnection
con;<BR><FONT color=red face="">con.setOption( "UseAPI" )
= "DB-Library";</FONT><BR>con.setClient(
SA_SQLServer_Client );<BR>con.Connect(...); </FONT>
</P>
<P align=left>For more connection details see <A
href="SQLServer_OleDb.html#Connecting to a database">SQL Server (OLE
DB)</A> and <A
href="SQLServer_DbLibrary.html#Connecting to a database">SQL Server
(DB-Library)</A> specific
information.
</P>
<P align=left>It's preferably to use OLE DB
because DB-Library has some limitations. Furthermore, DB-Library
interface is unchanging, it may not support new server features and
is likely to be discontinued (by Microsoft) at a future
date.
</P>
<P align=left>
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>
</center>
<p> </p></td>
<tr></tr>
</table></FONT>
</body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -