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.
Select the System DSN Tab and Click "Add..."
Then Select a driver Microsoft Access Driver (*.mdb) or SQL Server.
This is what is going to be used to set up the data source.
For Help on setting up SQL Server see How To: Setup a DSN-Access
Give the new Data Source a name and select a Server to connect to.
Then configure the authentication of the login ID and click "Next >".
Select the database to which you want to connect by checking the Change the default database to option and selecting the database from the drop down.
Click "Next >".
This section shows further settings which can be changed for the data source.
The Data Source connection can then be tested.
|Knowledge Base Article Ref:||KB13103018|