DriveWorks Pro 15: How To: Setup a DSN-Access (KB13103016) [send feedback...]

Introduction

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.

Microsoft Access Database Engine

We recommend installation of the 2010 Microsoft Access Database Engine (click to follow link) when communicating with any Microsoft Access database - both 32bit and 64bit versions available.

This must be installed on each machine the data source is accessed from.

Step 1.

Select the System DSN Tab and Click "Add..."

Step 2.

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.

Click "Finish".

For Help on setting up SQL Server see How To: Setup a DSN-SQL Server

Step 3.

Give the new Data Source a name and click "Select".

Step 4.

Then search for the Data Source.

If the Data Source is shared over a network the click the "Network" and Browse to the required server.

Once the data source has been found click "OK"

Step 5.

If the .mdb Data Source has 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.

Click "OK".


Knowledge Base Article Ref:KB13103016

Table of Contents