The Data Source utility (dbdsn) supports the following ODBC connection parameters. Boolean (true or false) arguments are either YES or 1 if true, or NO or 0 if false.
|Delphi||Delphi cannot handle multiple bookmark values for a row. When you set this value to NO, one bookmark value is assigned to each row, instead of the two that are otherwise assigned. Setting this option to YES can improve scrollable cursor performance.|
This parameter lets you specify how often you want a cursor to be re-described when a procedure is called. The default setting is If Required.
|Description||This parameter allows you to provide a description of the ODBC data source.|
This parameter allows you to specify an ODBC driver for the connection, as follows:
On Unix, this parameter specifies the fully-qualified path to the shared object. If you do not specify the Driver connection parameter on Unix, the Data Source utility automatically adds a Driver entry with the full path of the SQL Anywhere ODBC driver based on the setting of the SQLANY16 environment variable.
This parameter specifies the escape character used in the LIKE clause of SQL statements that are generated by the ODBC driver when returning a list of tables or columns.
By default the ODBC driver uses the tilde character (~), but some applications assume that the escape character is the backslash character (\).
The following connection string fragment specifies that the backslash is the escape character:
|GetTypeInfoChar||When this option is set to YES, CHAR columns are returned as SQL_CHAR instead of SQL_VARCHAR. By default, CHAR columns are returned as SQL_VARCHAR.|
|InitString||InitString allows you to specify a command that is run immediately after the connection is established. For example, you may want to set a database option or call a stored procedure.|
You can specify one of the following values to set the initial isolation level for this data source:
|KeysInSQLStatistics||Set this parameter to YES if you want the SQLStatistics function to return foreign keys. The ODBC specification states that SQLStatistics should not return primary and foreign keys; however, some Microsoft applications (such as Microsoft Visual Basic and Microsoft Access) assume that primary and foreign keys are returned by SQLStatistics.|
|LazyAutocommit||Set this parameter to YES to delay the commit operation until a statement closes.|
|PrefetchOnOpen||When PrefetchOnOpen is set to YES, a prefetch request is sent with a cursor open request. The prefetch eliminates a network request to fetch rows each time a cursor is opened. Columns must already be bound for the prefetch to occur on the open. This connection parameter can help reduce the number of client/server requests to help improve performance over a LAN or WAN.|
|PreventNotCapable||The SQL Anywhere ODBC driver returns an error because it does not support qualifiers. Some ODBC applications do not handle this error properly. Set this parameter to YES to prevent this error code from being returned, allowing these applications to work.|
|SuppressWarnings||Set this parameter to YES to suppress warning messages that are returned from the database server on a fetch. Versions 8.0.0 and later of the database server return a wider range of fetch warnings than earlier versions of the software. For applications that are deployed with an earlier version of the software, you can select this option to ensure that fetch warnings are handled properly.|
Set this parameter to a comma-separated list of data type names to prevent the ODBC driver from returning information about the specified data types. The specified data types are not returned by the SQLGetTypeInfo or the DatabaseMetaData.getTypeInfo functions. But, the application can use the data type in column declarations and in result set queries. For example, the following connection-string fragment prevents the ODBC driver from returning information about the NVARCHAR, LONG VARCHAR, and VARBIT data types.
|TranslationDLL||This option is provided for backward compatibility. The use of translators is not recommended.|
|TranslationName||This option is provided for backward compatibility. The use of translators is not recommended.|
|TranslationOption||This option is provided for backward compatibility. The use of translators is not recommended.|
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|