Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » ODBC Configuration Dialog Help » SQL Anywhere ODBC driver

Using the ODBC Configuration dialog Next Page

ODBC Configuration dialog: ODBC tab


This tab appears only when you are creating or modifying ODBC data sources.

The ODBC tab of the ODBC Configuration dialog has the following components:

Data source name    Type a name to identify this ODBC data source. You can use any descriptive name for the data source (spaces are allowed) but it is recommended that you keep the name short, as you may need to enter it in connection strings.

See DataSourceName connection parameter [DSN].

Description    You can provide a description of the data source. This description may help you or your end users to identify this data source from among their list of available data sources. This is an optional field.

Isolation level    Type a numerical value to specify the initial isolation level for this data source:

See Choosing isolation levels.

Microsoft applications (Keys in SQLStatistics)    Select this option 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 Visual Basic and Access) assume that primary and foreign keys are returned by SQLStatistics.

Delphi applications    Select this option if you use the Borland Delphi application development tool to create applications that produce your data source.

When this option is selected, one bookmark value is assigned to each row instead of the two that are otherwise assigned (one for fetching forward and a different one for fetching backward).

Delphi cannot handle multiple bookmark values for a row. If the option is cleared, scrollable cursor performance can suffer since scrolling must always take place from the beginning of the cursor to the row requested in order to get the correct bookmark value.

Suppress fetch warnings    Select this option if you want to suppress warning messages that are returned from the database server on a fetch.

Versions 8.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.

Prevent driver not capable errors    The SQL Anywhere ODBC driver returns a Driver not capable error because it does not support qualifiers. Some ODBC applications do not handle this error properly. Select this option to prevent this error code from being returned, allowing these applications to work.

Delay AutoCommit until statement close    Select this option to delay the commit operation until a statement closes.

Describe Cursor Behavior    Choose how often you want a cursor to be redescribed when a procedure is executed. The default setting is If Required.

Translator    The translator converts characters between ANSI and OEM code pages. Most databases do not require a translator because the ODBC Driver Manager automatically performs a conversion between the client's character set and the database's character set. If your database uses an ANSI code page (the default) do not select a translator.

If you require a translator, click Select and choose the translator from the list of installed translators.

Test Connection    Tests whether the information provided results in a proper connection. In order for the test to work, a user ID and password must be specified on the Login tab.