Accessing Databases with ODBC (Windows)

If your application needs to access external databases through ODBC, you
can create the necessary ODBC connection in Plesk. After you have
created the ODBC connection, you can customize the application to use
that ODBC connection to access information in the database.

Note that the database does not necessarily need to be external; ODBC
can be used to access local databases as well.

To create a new ODBC connection to a database:

1. Go to Websites & Domains and click ODBC Data Sources.

2. Click Add ODBC DSN.

3. Specify the ODBC connection name and description in the corresponding
   fields.

4. Select the required driver in the Driver field.

5. Click OK.

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

7. Click Test to check whether the connection will function properly
   with provided settings. Click Finish to complete the creation.

   

To change settings of an existing ODBC connection:

1. Go to Websites & Domains and click ODBC Data Sources.
2. Click the required connection name in the list.
3. Change the settings as needed.
4. Click Test to check whether the connection will function properly
   with new settings. Click Finish to save changes.

To remove an ODBC connection:

1. Go to Websites & Domains and click ODBC Data Sources.
2. Select the checkbox next to the connection you want to remove.
3. Click Remove, confirm the removal and click OK.