On a 32bit machine the ODBC can be found at Start > Programs > Control Panel > Administrative Tools > Data Source (ODBC).
On a 64bit machine the ODBC can be found at Start > Programs > Control Panel > Administrative Tools > Data Source (ODBC)
Connecting to a 32bit Data Source on a 64bit machine
When connecting to a 32bit Data Source on a 64bit machine the 32bit ODBC Data Source Administrator which is found at C:\windows\syswow64\odbcad32.exe must be used.
Microsoft Excel based projects
When using DriveWorks database connection functions (QueryData, GetData, etc.) in a Microsoft Excel based project, on a 64bit machine the same DSN must be configured in the 64bit ODBC Data Source Administrator AND the 32bit ODBC Data Source Administrator.
Microsoft Access Database Engine
We recommend installing the 2010 Microsoft Access Database Engine (click to follow link) when communicating with any Microsoft Access database - both 32bit and 64bit versions are available.
This must be installed on each machine that the Data Source will be accessed from.
Select the System DSN Tab and click Add...
Select a driver Microsoft Access Driver (*.mdb) or SQL Server.
This driver is going to be used to set up the Data Source.
For Help on setting up SQL Server see How To: Setup a DSN-SQL Server
Give the new Data Source a name and click Select.
Now locate the Data Source.
If the Data Source is shared over a network then click the Network and locate the required server.
Once the Data Source has been located click OK.
If the .mdb Data Source requires a password then this can be entered by clicking Advanced....Otherwise this will need to be entered when writing a rule for the Data Source.
|Knowledge Base Article Ref:||KB13103016|