Configuring ODBC

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, 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.

After the Data Source Name connection is configured, it appears in the list on the ODBC Management page. To remove a data source name, select the corresponding checkbox and click Remove Selected. You will then be prompted to confirm removing. Select the checkbox to confirm and click OK.

Was this answer helpful? 21 Users Found This Useful (51 Votes)