Accessing Databases with Connection Strings 

Another method of connecting to a database is using a connection string. A connection string is a string that contains information about a data source (usually a database engine), as well as the information necessary to connect to it. While the exact syntax of a connection string varies depending on the data source (for example, a connection string meant to connect to a MySQL database server will look different than one for a PostgreSQL server), you will usually be required to specify the following data:

  • Database server address. To find out your database server address do the following:
    1. Go to Websites & Domains and click Databases.
    2. Click the Webadmin link for one of your databases.
    3. At the top of the screen look for an entry of the following form “Server: 10.58.103.102:3306”. In this example, ‘10.58.103.102’ is the database server address. If the server name is specified like ‘localhost’, contact your hosting provider to find out your database server address.
  • Database name. To find out the exact name of your database, go to Websites & Domains and click Databases to see the list of your databases.
  • Database user login and password. To find out the login of the database user, do the following:
    1. Go to Websites & Domains and click Databases.
    2. Note the name in the Users column next to the database to which you want to connect using the connection string.
  • If you do not remember the user’s password, you can reset it. To reset the user’s password, do the following:
    1. Go to Websites & Domains and click Databases.
    2. Click User Management and click the corresponding name in the Name column.
    3. Type in the new password and confirm it. Click OK.

This document does not aim to provide an in-depth description of connection strings’ syntax. If you want to learn more about the subject, we recommend that you visit Microsoft To Download the ODBC Driver for more information.

Related Articles

Adding a Domain Forwarder

To create a domain forwarder in Plesk: Start creating a new domain in Websites & Domains > Add Domain and specify the following: In the Domain name box, type the domain

Configuring DNS for a Domain Cover Image

Configuring DNS for a Domain

The Domain Name System (DNS) is a hierarchical naming system that translates understandable domain names into the numerical identifiers (IP addresses) associated with web hosts.

Website Status 002

Website Status

The website status defines whether a website is available over the Internet and what hosting services are provided for it. The hosting provider may need to change

Website Hosting

WEBSITE HOSTING The Website hosting means that a website is physically located on the server. For the website hosting type you can specify: Document root. The location

Our Service Locations

The Palm Beaches

Coming Soon

Miami / Fort Lauderdale

Coming Soon