Home Search

DriveWorks Pro 19
How To: Set up a DSN-Access (KB13103016)

Send Feedback

How To: Set up a DSN-Access

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.

Step 1.

Select the System DSN Tab and click Add...

Step 2.

Select a driver Microsoft Access Driver (*.mdb) or SQL Server.

This driver 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.

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.

Step 5.

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.

Click OK.


Knowledge Base Article Ref:KB13103016