|
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=demo10;DatabaseName=demo
This chapter has many examples of connection strings 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.