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.
| Step 1. | Select the System DSN tab and click Add... | |
|---|---|---|
| Step 2. | Select SQL Server. This driver will be used to set up the data source. For Help on setting up SQL Server see How To: Setup a DSN-Access Click Finish. | |
| Step 3. | Give the new Data Source a name and select a Server to connect to. Click Next. | |
| Step 4. | Then configure the authentication of the login ID and click Next >. | |
| Step 5. | Select the required database you want to connect by checking the Change the default database to option and selecting the database from the drop down. Click Next >. | |
| Step 6. | This section shows further settings which can be changed for the Data Source. Click Finish. | |
| Step 7. | The Data Source connection can then be tested. Click OK. |
| Knowledge Base Article Ref: | KB13103018 |
|---|