Use the ODBC tab on the ODBC configuration dialog to specify attributes such as the data source name.
Area |
Description |
|---|---|
ODBC tab – 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 enter it in connection strings. |
ODBC tab – Description |
You can enter an optional longer description of the data source. |
ODBC tab – Isolation level |
The isolation level for an SAP Sybase IQ data source is always effectively 3. However, the default catalog store isolation level is 0. You should generally leave this blank. |
ODBC tab – Microsoft applications (Keys in SQL Statistics) |
Check this box if you wish foreign keys to be returned by SQL statistics. The ODBC specifications states that primary and foreign keys should not be returned by SQL statistics, however, some Microsoft applications (such as Visual Basic and Access) assume that primary and foreign keys are returned by SQL Statistics. |
ODBC tab – Delphi applications |
Check this box to improve performance for Borland Delphi applications. Checking this option assigns one bookmark value to each row, instead of the two that are otherwise assigned (one for fetching forwards and a different one for fetching backwards). |
ODBC tab – Suppress fetch warnings |
Check this box to suppress warning messages that are returned from the database server on a fetch. |
ODBC tab – Prevent driver not capable errors |
The SAP Sybase IQ 16 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. |
ODBC tab – Delay AutoCommit until statement close |
Force the SAP Sybase IQ 16 ODBC driver to delay the commit operation until a statement has been closed. |
ODBC tab – Describe cursor behavior |
Select how often you wish a cursor to be re-described when a procedure is executed or resumed. |
ODBC tab – Translator |
Choose MS Code Page Translator if your database uses an OEM code page. If your database uses an ANSI code page, which is the default, leave this unchecked. |
ODBC tab – Test Connection |
Test that the information provided results in a proper connection. In order for the test to work, you must have specified a user ID and password. |