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.
For more information, see the DataSourceName connection parameter in the Sybase IQ Reference Manual.
Description You can enter an optional longer description of the Data Source.
Translator Choose Adaptive Server Anywhere 7.0 Translator if your database uses an OEM code page. If your database uses an ANSI code page, which is the default, leave this unchecked.
Isolation level The isolation level for a Sybase IQ data source is always effectively 3. However, the default Catalog Store isolation level is 0. You should generally leave this blank.
For more information, see Chapter 10, “Transactions and Versioning.”
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 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.
Sybase IQ version 12 and later 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 Sybase IQ 12 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 wish the Sybase IQ 12 ODBC driver to delay the commit operation until a statement has been closed.
Describe cursor behavior Select how often you wish a cursor to be re-described when a procedure is executed or resumed.
Test Connection Tests if the information provided will result in a proper connection. In order for the test to work a user ID and password must have been specified.
