Print Add to Favorites   Back
Setting up a Microsoft Acccess ODBC connection


Article Information
Article ID: 2
Author: Noah Juergenson
Created: 6/27/2007
Modified: 6/27/2007
Views: 206

If you want your users to access the data from an external database management system, you should use Open Database Connectivity (ODBC) drivers. For example, you can install a Microsoft Access ODBC driver, creating a connection to external Microsoft Access database, and let web applications use this database for storing their data.

To install a new ODBC driver, creating a connection to an external database:

  1. Click the Server shortcut in the navigation pane.
  2. Click ODBC Data Sources in the Services group.
  3. Click Add New ODBC DSN.
  4. Specify the ODBC connection name and description in the corresponding fields.

    This is a sample path:
    "D:\vhosts\yourdomain.com\private\db\databasename.mdb"

  5. Select the required driver in the Driver field.
  6. Click OK.
  7. Choose the appropriate options on the driver configuration screen. Typically, you should specify the path to the database, user credentials and other connection options, depending on the selected driver.

Click Test to check whether the connection will function properly with provided settings. Click Finish to complete the creation.


This URL: http://66.42.64.227:9996/Customer/KBArticle.aspx?articleid=2