Database Connection Strings

A database connection string provides an application with all of the information needed to connect to a database.

This information depends on the type of database, but usually includes a user name, password, server name, database name, and so on.

"user id=sa;password=sql;server=localhost;database=expere;"

For Oracle, a typical connection string may resemble the following:

"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=mn02ws1finnelb)(
PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=orcl)));User 
Id=fw3;Password=fw3;"

The keys in the connection strings (user id, password, server, data source, etc.) are not case sensitive.

For details on the options available, please refer to the documentation from your database vendor.