Sybase 12.4.2 manual Prevent Driver Not Capable errors

The Adaptive Server Anywhere

Creating and editing ODBC data sources

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.

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.

Prevent Driver Not Capable errors

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

Adaptive Server Anywhere 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.

68