Sybase 12.4.2 Manuale Utente

Creating and editing ODBC data sources

 

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.

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.

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.

Check this box if you wish the 

Adaptive Server Anywhere ODBC driver to delay the commit operation until 
a statement has been closed.

Select how often you wish a cursor to be re-

described when a procedure is executed or resumed.

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.