Ispirer Ispirer

Ispirer Home Page Request SQLWays

Access ODBC Driver Configuration

To set up the Access ODBC Driver for Windows, follow the steps below:

1. Go to the “ODBC Administrator”. If you are using the 32-bit version of SQLWays on the 64-bit machine you need to use the 32-bit “ODBC Administrator” (you can find it here c:\Windows\sysWOW64\odbcad32.exe). The ODBC Data Source Administrator window is displayed.

2. Click on the “Add” button. The “Create New Data Source” dialog is displayed, enabling you to add a new DSN.

3. Select “Driver to Microsoft Access” and click on the “Finish” button.

4. The FoxPro ODBC Driver Setup Dialog will appear. And in this dialog you need to enter the following configuration details:

  • The data source name for connection;
  • Select database file path;

See the example below:

Provide Data Source Name and click “Select” button:

And select the path to the database you need to connect to:

To update the list of ODBC connections in the SQLWays Wizard, please restart it.

Your Access connection is now available to be used in SQLWays Wizard.

Ispirer Home Page Request SQLWays

sqlways/users-guide/setting-up-database-connection/access/driver.txt · Last modified: June 20, 2018, 01:20:56 PM by anastasiya.shpakava
© 1999-2021, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement