Connectors : Additional Connectivity Details : Installing an ODBC Driver
 
Share this page                  
Installing an ODBC Driver
We do not sell or distribute ODBC drivers. You must obtain ODBC drivers from another vendor.
Some basic ODBC drivers are installed automatically with Windows operating systems. However, the drivers are not configured automatically, so you must do this by using the operating system ODBC administrator privileges.
Note:  In Windows, the ODBC administrator is called Data Sources (ODBC) and is found in Control Panel > Administrative Tools.

In current versions of Windows on 64-bit platforms, the administrator is ODBC Data Sources (64-bit). There is also a 32-bit variant. But for DataConnect, 64-bit data sources are required.
Data Direct ODBC Drivers
ODBC driver vendor Merant (formerly Pioneer, Q+E, Intersolve, Microfocus) has become Data Direct Technologies, Inc. For their ODBC driver information, see http://www.datadirect.com/download/index.ssp.
To add a data source to ODBC Control Panel
1. Go to Start > Settings > Control Panel.
2. Open the ODBC icon.
3. The User DSN tab appears. Click Add.
4. The Create New Data Source window appears. Select the appropriate driver and click Finish. (If a driver for the application that you want to connect to does not appear in the list, you need to install the driver.)
5. The Data Source Setup window appears for that driver. The next step is to enter a name for the source.
Note:  From this point forward, procedure varies slightly depending on the driver. Check the documentation of your particular driver for specifics as to how to set it up.
6. Click Select.
7. The Select Database window opens. Navigate to a Navision Financials database file.
8. Click OK. Click OK again.
9. The new Data Source Name now appears in the list in the User DSN tab. The name of the driver is in parentheses next to it. Close the ODBC administrator.
You are now ready to open the integration platform and connect to the new data source.
See Also
ODBC Connectivity Tips