Domainplus domain management system FAQ

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 Config button on the Server Administration page.

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

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

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

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

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

  5. Click the Check settings button to check all specified settings, or select the Test connection button to attempt connecting to the data source with the given login and password.

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

You can sort the data sources by name, clicking on the Connection name heading of the list.

To search in the data source names, enter a search string in the input field next to the Search button, click Search. The results matching the entered string will be displayed in a form of reduced list. Click Show All to revert to displaying the entire list.

To remove a data source name, select it using the appropriate checkbox in the Sel column and click Remove Selected. You will then be prompted to confirm removing. Check the checkbox to confirm and click Submit.

back to Table of Contents
Partners: Web Site Designers
back to domainplus domain name registration