connection_setoption.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.<BR>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_Option.html">Option</A> 
			</p>
			<p>
			<A href="Command_setOption.html">Command::setOption</A>, 
            
			<A href="Command_Option.html">Command::Option</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>