Documentation Center

Sample database connection strings

This topic provides examples of connection strings for SQL Server and Oracle databases.

Connection strings for SQL Server

The following is an example of a standard connection string for Microsoft SQL Server:
Provider=MSOLEDBSQL.1;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
The following is an example of a standard connection string for Microsoft SQL Server that includes a trusted connection using Integrated Security:
Provider=MSOLEDBSQL.1;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

When using Integrated Security, the user specified in the Input Parameter OSUser used by InstallTool, should have sufficient privileges on the database.

Connection strings for Oracle

The following is an example of a standard connection string for Oracle:
Provider=OraOLEDB.Oracle.1;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
The following is an example of a standard connection string for Oracle with OS Authentication:
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=/;Data Source=MyOracleDB