How to Accessing External Databases in Plesk 11.5x?
If your applications need to access external databases for storing data, then you need to create ODBC connections through the Panel.
To create an ODBC connection to an external database:
- If you are subscribed to several hosting packages and have access to several webspaces associated with your account, in the Subscription menu at the top of the screen, select the required webspace.
- Go to the Websites & Domains tab > ODBC Data Sources (in the Advanced Operations group).
- Click Add New ODBC DSN.
- Specify the ODBC connection name and description in the corresponding fields.
- 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 Connection to check whether the connection will function properly with provided settings.
- Click Finish to complete the creation.
To change settings of an ODBC connection:
- Go to the Websites & Domains tab > ODBC Data Sources (in the Advanced Operations group).
- Click the required connection name in the list.
- Change the settings as needed.
- Click Test Connection to check whether the connection will function properly with new settings. Click Finish to save changes.
To remove an ODBC connection:
- Go to the Websites & Domains tab > ODBC Data Sources (in the Advanced Operations group).
- Select the checkbox corresponding to a connection you want to remove.
- Click Remove, confirm the removal.
- Click OK.