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:
- Click the Server shortcut in the navigation pane.
- Click
ODBC Data Sources in the Services group.
- Click
Add New ODBC DSN.
- Specify the ODBC connection name and description in the corresponding fields.
This is a sample path:
"D:\vhosts\yourdomain.com\private\db\databasename.mdb"
- Select the required driver in the Driver field.
- Click OK.
- 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.