Contents Index Configuring ODBC data sources using the ODBC Administrator Login tab

ASA Database Administration Guide
  Connecting to a Database
    Working with ODBC data sources
      Configuring ODBC data sources using the ODBC Administrator

ODBC tab

This tab provides fields related to ODBC data sources and appears only when you are creating or modifying ODBC data sources.

Data source name    The Data Source Name is used to identify the 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 type it in connection strings.

For more information, see DataSourceName connection parameter [DSN].

Description    You may type an optional longer description of the Data Source to help you or end users to identify this data source from among their list of available data sources. This field is optional.

Isolation level    Type the desired isolation level for this data source:

For more information, see Choosing isolation levels.

Microsoft applications (Keys in SQLStatistics)    Check this box if you want foreign keys to be returned by the SQLStatistics function. 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    Check this box to improve performance for Borland Delphi applications. When this option is checked, one bookmark value is assigned to each row, instead of the two that are otherwise assigned (one for fetching forwards and a different one for fetching backwards).

Delphi cannot handle multiple bookmark values for a row. If the option is unchecked, 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    Check this box 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 Adaptive Server Anywhere ODBC driver returns a Driver not capable error code because it does not support qualifiers. Some ODBC applications do not handle this error properly. Check this box to disable this error code, allowing such applications to work.

Delay AutoCommit until statement close    Check this box if you want the Adaptive Server Anywhere ODBC driver to delay the commit operation until a statement has been closed.

Describe Cursor Behavior    Choose how often you wish a cursor to be redescribed when a procedure is executed or resumed. 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.

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 have been specified.


Contents Index Configuring ODBC data sources using the ODBC Administrator Login tab