The Open Database Connectivity (ODBC) is an interface used to access data from a variety of database management systems. For example, if you have a program that accesses data in a SQL database, Data Sources (ODBC) will let you use the same program to access data in a Visual FoxPro database. To do this, you must add software components called drivers to your system. The ODBC DSN page within Plesk helps you add, configure, and remove these drivers. You access this page, clicking the ODBC icon on the Domain Administration page.

To add a new data source connection from the ODBC management page in Plesk, follow these steps:

1.       Click Add New ODBC DSN.

2.       Enter the name you would like to use to refer to the data source in the Connection name box, select the driver for which you are adding a data source and click OK. A driver-specific setup page will appear.

3.       Use the Server drop-down box to select the name of SQL server the driver will connect to.

4.       Use the Login ID and Password fields to specify the login ID and password the SQL Server driver will use to connect to SQL Server.

5.       You may need to supply any additional information, if requested by the driver.

6.       Once the required information is supplied, you can use the Test connection option to attempt connecting to the data source with the given credentials.

7.       Click Finish to complete creation of the data source name.

8.       Please modify the permission for IUSR_username for the Access (.mdb) file with read and write permission using the Permission Icon within File Manager

Thank Laurence for this tutorial