connection_option.html

通用的数据库中间库

                        href="../ServerSpecific/Sybase.html" title="Sybase server specific information">Sybase</A></STRONG></p>
					</td>
					<td>
                        <P><STRONG>CS_PACKETSIZE</STRONG><BR>Determines the packet size that Client-Library uses 
                        when sending Tabular Data Stream (TDS) packets. For more 
                        information see Sybase documentation.<BR>Connection related. Should be specified before 
                        actual connection is made.<BR>Valid 
                        values: String containing packet size, see Sybase 
                        documentation.<BR>Default value: see 
                        Sybase documentation.</P>
                        <P><STRONG>CS_APPNAME</STRONG><BR>Defines 
                        the application name that a connection will use when 
                        connecting to a server. For more information see Sybase 
                        documentation.<BR>Connection related. 
                        Should be specified before actual connection is made.<BR 
                        >Valid values: see Sybase 
                        documentation.<BR>Default value: see 
                        Sybase documentation.</P>
                        <P><STRONG>CS_HOSTNAME</STRONG><BR>Declares 
                        the name of the host machine, used when logging in to a 
                        server. For more information see Sybase 
                        documentation.<BR>Connection related. 
                        Should be specified before actual connection is made.<BR 
                        >Valid values: see Sybase 
                        documentation.<BR>Default value: see 
                        Sybase documentation.</P>
					</td>
				</tr>
				<tr>
					<td>
						<p><STRONG><A 
                        href="../ServerSpecific/DB2.html" title="DB2 server specific information">DB2</A></STRONG></p>
					</td>
					<td>
						<p> 
                           None</p>
					</td>
				</tr>
				<tr>
					<td>
						<p><STRONG><A 
                        href="../ServerSpecific/Informix.html" title="Informix server specific information">Informix</A></STRONG></p>
					</td>
					<td>
						<p> 
                           None</p>
					</td>
				</tr>
				<tr>
					<td>
						<p><STRONG><A 
                        href="../ServerSpecific/InterBase.html" title="InterBase server specific information">InterBase</A></STRONG></p>
					</td>
					<td>
                        <P><STRONG>isc_dbp_lc_ctype</STRONG><BR>Specifies the 
                        character set to be utilized. For more information see 
                        InterBase documentation.<BR>Connection related. Should 
                        be specified before actual connection is made.<BR>Valid 
                        values: String containing character set name, see 
                        InterBase documentation.<BR>Default 
                        value: see InterBase documentation.</P>
                        <P><STRONG>isc_dbp_sql_role_name</STRONG><BR>Declares 
                        role name that should used for connection. For more 
                        information see InterBase documentation.<BR>Connection 
                        related. Should be specified before actual connection is 
                        made.<BR>Valid values: see InterBase documentation.<BR 
                        >Default value: see InterBase 
                        documentation.</P>
                        <P><STRONG>isc_dpb_num_buffers</STRONG><BR>Declares the number of database cache buffers 
                        to allocate for use with the database. For more 
                        information see InterBase documentation.<BR>Connection 
                        related. Should be specified before actual connection is 
                        made.<BR>Valid 
                        values: 10-255, see InterBase documentation.<BR 
                        >Default value: 75, see InterBase 
                        documentation.</P>
                        <p><STRONG>CommitRetaining<BR></STRONG>Determines which function (<EM 
                        >isc_commit_transaction()</EM> or 
                        <EM>isc_commit_retaining()</EM>) 
                        SQLAPI++ calls&nbsp; to commit transactions.<BR 
                        ><EM>isc_commit_transaction()</EM> writes transaction 
                        changes permanently to a database, closes the result set 
                        associated with the transaction, and frees system 
                        resources assigned to the transaction for other uses. 
                        Active result sets are not preserved.<BR><EM>isc_commit_retaining()</EM> writes all pending 
                        changes to the database, ends the current transaction 
                        without closing its record stream and cursors and 
                        without freeing its system resources, then starts a new 
                        transaction and assigns the existing record streams and 
                        system resources to the new transaction. Active result 
                        sets are preserved. <BR>For more 
                        information see InterBase documentation (<EM 
                        >isc_commit_retaining()</EM> and <EM 
                        >isc_commit_transaction()</EM> 
                        functions). <BR>Connection related. Should 
                        be specified before issuing a commit.<BR 
                        >Valid values: &quot;true&quot; to 
                        force SQLAPI++ to call <EM>isc_commit_retaining()</EM> function, 
                        &quot;false&quot; to force SQLAPI++ to call <EM 
                        >isc_commit_transaction()</EM> 
                        function.<BR>Default value: 
                        &quot;false&quot;. SQLAPI++ uses <EM>isc_commit_transaction()</EM> function by 
                        default.</p>
					</td>
				</tr>
				<tr>
					<td>
						<p><STRONG><A 
                        href="../ServerSpecific/SQLBase.html" title="SQLBase server specific information">SQLBase</A></STRONG></p>
					</td>
					<td>
                        <P>   
                               
                          None</P>
					</td>
				</tr>
				<tr>
					<td>
						<p><STRONG><A 
                        href="../ServerSpecific/MySQL.html" title="MySQL server specific information">MySQL</A></STRONG></p>
					</td>
					<td>
                        <p>  None 
                        </p>
					</td>
				</tr>
				<tr>
					<td>
						<p><STRONG><A 
                        href="../ServerSpecific/PostgreSQL.html" title="PostgreSQL server specific information">PostgreSQL</A></STRONG></p>
					</td>
					<td><p><STRONG> 
                                    
                              
                        UseDLLonWin32<BR></STRONG>Forces SQLAPI++ Library to use pq.dll or 
                        libpq.dll when you are working on Win32 platform.<BR 
                        >Connection related. Should be specified 
                        before the first connection is 
                        made.<BR>Valid values: &quot;CygWin&quot; and 
                        &quot;Native&quot;. 
				<BR>
					Default 
                        value: &quot;Native&quot;. SQLAPI++ uses libpq.dll as 
                        the default API DLL. 
						Setting 
                        &quot;CygWin&quot; value of this option forces SQLAPI++ 
                        to use pq.dll.</p>
					</td>
				</tr>
				<tr>
					<td>
						<p><STRONG><A 
                        href="../ServerSpecific/ODBC.html" title="ODBC server specific information">ODBC</A></STRONG></p>
					</td>
					<td>
					<p>
						<STRONG>UseManagerOnUNIX<BR></STRONG>Forces 
                        SQLAPI++ Library to use specified library on UNIX.<BR 
                        >    Connection 
                        related. Should be specified 
                        before the first connection is made. 
						<BR 
                        > 
                           Valid values: &quot;&lt;name of 
                        library you want to use&gt;&quot;. 
				<BR>
					Default value: 
                &quot;libiodbc.so.2&quot;.
					</p>
					</td>
				</tr>
            </table>
			
			<h3>See also</h3>
			<p>
			<A href="Connection_setOption.html">setOption</A> 
			</p>
			<p>
			<A href="Command_Option.html">Command::Option</A>, 
			<A href="Command_setOption.html">Command::setOption</A> 
			</p>
			<p>
			<A href="Command.html">SACommand</A>,   
			<A href="String.html">SAString</A> 
			</p>

			<h3>Problems and Questions</h3>
			<p>
			If 
			you don't find the answer to you questions or 
            have some problems on using the Library, please, send e-mail to <A href="mailto:[e-mail]">[e-mail]</A>.
			</p>
		</td>
	<tr></tr>
</table>
</body>
</html>