When an application connects to a database, it uses a set of connection parameters to define the connection. Connection parameters include information such as the server name, the database name, and a user ID.

A keyword-value pair (of the form parameter=value) specifies each connection parameter. For example, you specify the password connection parameter for the default password as follows:

Password=sql

Connection parameters are assembled into connection strings. In a connection string, a semicolon separates each connection parameter, as follows:

ServerName=demo11;DatabaseName=demo

Representing connection strings

Connection string examples can be represented in the following form:

parameter1=value1
parameter2=value2
...

This is equivalent to the following connection string:

parameter1=value1;parameter2=value2

You must enter a connection string on a single line with the parameter settings separated by semicolons.