Creating ODBC DSN through PLESK

Creating ODBC DSN through PLESK

 

   Creating ODBC DSN through PLESK

     Description: A Data Source Name (DSN) is the ODBC logical name for the drive and other information the database needs to access data.

                         The name is used by Internet Information Services (IIS) for a connection to an ODBC data source. 

   Step 1. To create ODBC DSN at first Login into Plesk Panel then select Websites & Domains after that click on ODBC Data Sources.

      

      Step 2: Now Click on the Add ODBC DSN connection.

      

     Step 3: Add connection name, then under driver option select your db driver for which you want to add ODBC DSN connection and the click OK

   

    Step 4: Select the proper "Login ID", "Password","Default Database for the ODBC data source.

      

    

       Click "Test Connection" to test the connectivity with the database.Click "Next" and then "Finish" to complete the DSN creation.

      

   

   

   

   

   



    • Related Articles

    • Bulk email ID creation on Plesk

      Bulk email ID creation on Plesk Follow the below steps to create Bulk Email ID on Plesk 1.Connect to the server via SSH/RDP. 2.Create a file mail.txt using any text editor with a list of mail addresses and passwords for it: example1@example.com ...

    • Creating / Deleting an Email Alias in Plesk

      Creating / Deleting an Email Alias in Plesk Objective: This article demonstrates the process to Create or Delete an Email Alias (another name for the email address) for a particular email account. Create Email Alias Visit the URL ...

    • Creating a MySQL Database in Plesk

      Creating a MySQL Database in Plesk Visit the URL http://<your_domain>:8880 or https://<your_domain>:8443 (For SSL) Step 1: Log in to the Plesk Control Panel to create a MySQL Database and click on Website and Domain then select Database Click on add ...

    • Creating Customers For Each Subscription

      Creating Customers For Each Subscription in Plesk Panel Objective: Creating Customers to authenticate for accessing any subscription from Plesk Control Panel Create Customer in Plesk panel Assign a Subscription to any Customer Step 1: Steps to create ...

    • Important Plesk CLI Commands

      Important Plesk Linux CLI Commands If Plesk throws an error, these logs will help. /usr/local/psa/var/log /opt/psa/admin/logs /var/log/sw-cp-server/error_log /usr/local/psa/admin/logs/panel.log /usr/local/psa/admin/logs/httpsd_access_log ...