Home Search

DriveWorks Pro 19
How To: Set up a DSN-SQL Server (KB13103018)

Send Feedback

How To: Set up a DSN-SQL Server

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 in an Excel based project (64bit machine), the same DSN must be configured in the 64bit ODBC Data Source Administrator AND the 32bit ODBC Data Source Administrator.

Step 1.

Select the System DSN tab and click Add...

Step 2.

Select a driver Microsoft Access Driver (*.mdb) or 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.

How To: Setup a DSN-Access

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