ODBC data sources fail on 64-bit machines

(CR #454413) On a 64-bit machine, ODBC data sources do not work, because SQL Anywhere is a 32-bit application and is incompatible with the ODBC system data source name (DSN). The DSN is the logical name that ODBC uses to access data.

Workaround: Either register the system DSN or define a user DSN.

Select Start | Run.

To register the system DSN:
1. In the Run dialog, enter C:\Windows\SysWOW64\odbcad32.
2. In the ODBC Administrator, select the System DSN tab.
To define a user DSN:
1. In the Run dialog, enter odbcad32.
2. In the ODBC Administrator, select the User DSN tab.
Select the data source name, and click Add.
Select the database driver, then click Finish.
Configure these DSN properties:
- Database Driver Path to the SQL Anywhere installation; for example: C:\Program Files\Sybase\EAServer6\ASA100.
- User ID For example, the default: dba
- Password For example: sql
- Database Name default
- Database File Path to default.db; for example: C:\Program Files\Sybase\EAServer6\data\default.db.
- Engine Name default
- Auto Stop yes
- Integrated no
- Debug no
- Disable Multirow Fetch no
- Compress no