Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software

ODBC Sybase ASA Driver Setup Dialog: ODBC Tab

The following shows the ODBC tab in the driver configuration. It is where you name the ODBC data source (DSN) you are configuring. This tab also contains the Test Connection button. This button allows you to test the connection to ASA, after you finish the configuring the DSN and before you exit out of the driver configuration utility. The following screen shows the sample ASA ODBC DSN created with the installation of the ASA network server.

In the Data source name box type a name to identify this 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.
In the Description box you can provide a description of the data source. This description may help you or your end users to identify this data source from among their list of available data sources. This is an optional field.
In the Isolation level box type a numerical value to specify the initial isolation level for this data source:
0 This is also called the read uncommitted isolation level. This is the default isolation level. It provides the maximum level of concurrency, but dirty reads, non-repeatable reads, and phantom rows may be observed in result sets.
1 This is also called the read committed level. This provides less concurrency than level 0, but eliminates some of the inconsistencies in result sets at level 0. Non-repeatable rows and phantom rows may occur, but dirty reads are prevented.
2 This is also called the repeatable read level. Phantom rows may occur. Dirty reads and non-repeatable rows are prevented.
3 This is also called the serializable level. This provides the least concurrency, and is the strictest isolation level. Dirty reads, non-repeatable reads, and phantom rows are prevented.
If the Microsoft applications (Keys in SQLStatistics) check box is selected, so the SQLStatistics function returns foreign keys. 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.
If the Delphi applications check box is selected the Borland Delphi application development tool is used to create applications that produce your data source.

When this option is selected, 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 cleared, 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.

If the Suppress fetch warnings check box is selected warning messages that are returned from the database server on a fetch are suppressed.

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 because it does not support qualifiers. Some ODBC applications do not handle this error properly. Select this option to prevent this error code from being returned, allowing these applications to work.
Delay AutoCommit until statement close Select this option to delay the commit operation until a statement closes.
Describe Cursor Behavior Choose how often you want a cursor to be redescribed when a procedure is executed. The default setting is If Required.
Never Select this option if you know that your cursors do not have to be redescribed. Redescribing cursors is expensive and can decrease performance.
If required When you select this option, the ODBC driver determines whether a cursor must be redescribed. The presence of a RESULT clause in your procedure prevents ODBC applications from redescribing the result set after a cursor is opened. This is the default.
Always The cursor is redescribed each time it is opened. If you use Transact-SQL procedures or procedures that return multiple result sets, you must redescribe the cursor each time it is opened.
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.

If you require a translator, click Select and choose the translator from the list of installed translators.

Select Translator Click Select Translator to choose the ODBC translator you require from a list of installed translators.
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 be specified on the Login tab.