Database Connect Strings

Database Connect Strings that can be used in the registry values (for example, connect), are described below. [M1840]

Supported Connect Strings for SQL SERVER

Standard Connect String
Provider=MSOLEDBSQL.1;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Trusted connection using Integrated Security
Provider=MSOLEDBSQL.1;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Supported Connect Strings for Oracle

Standard Connect String
Provider=OraOLEDB.Oracle.1;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
Connect String with OS Authentication
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=/;Data Source=MyOracleDB