Configuring ODBC

Configuring ODBC and creating data sources is required before WinSQL Professional can be used for database management.  The following topics describe these procedures.

32-bit Versus 64-Bit Architecture

WinSQL is available for both 32-bit as well as 64-bit architecture. There are three types of ODBC drivers:

·32-bit

·64-bit

·32-/64-bit

Depending upon the type of ODBC driver, you must use the appropriate architecture for WinSQL as well. If not, the following error will occur if you try to use a 32-bit driver with WinSQL64:

The specified DSN contains an architecture mismatch between the Driver and Application