# 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.

For the SQL Server, a typical connection string may resemble the following:

    "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.

Parent topic: Command Line Options