Registering ODBC Drivers

If using the ODBC drivers installed with WinSQL Professional, they must be registered prior to using them. Registering the drivers configures them so that they appear in ODBC Manager in Windows Control Panel.

The installer will automatically register these drivers for WinSQL32. These drivers are not available for WinSQL64

You can invoke the driver registration window by clicking Register ODBC Drivers under the Help menu. The following window displays:

The WinSQL ODBC Installer window displays all the available drivers installed with WinSQL Professional. The installation status displays next to the name of every driver.

You may see “Different App” next to a value if this particular driver is installed but is associated with a different binary. This occurs when both WinSQL 9 and WinSQL 10 are installed and a driver is registered with WinSQL 9.

Click Fix to modify the registration status. You may choose to register only the drivers that you want to use, or select all of them. Synametrics Technologies recommends that you register all the drivers.

Notes:

·To re-register or unregister a driver, click Help, and then click Register ODBC Drivers within WinSQL Professional.

·When drivers are unregistered, all associated data source names (DSNs) are also removed.

·WinSQL Professional works with all ODBC drivers, regardless of the manufacturer. Therefore, you do not have to register these drivers if you are planning to use a different driver to connect to your database.