On a 32bit machine the ODBC can be found at Start > Programs > Control Panel > Administrative Tools > Data Sorce (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..."
Select the driver that will be used to communicate with the database
This is what is going to be used to set up the data source.
Standard ODBC drivers should be provided by the vendor of the database you require connection with.
Please consult the vendors instructions for further setup procedure to allow connection.
|Knowledge Base Article Ref:||KB13103017|