Connection strings for Oracle

This page lists alternative connection strings you can use with Oracle database.

.NET Oracle provider.

For Standard security:

Connection string type:Oracle
Connection string:Data Source=MyOracleDB; User Id=myUsername;Password=myPassword;

For a Trusted connection:

OS Authenticated connect setting user ID to "/":

Connection string type:Oracle
Connection string:Data Source=MyOracleDB;User Id=/;Password=;

OS Authenticated connect using OSAuthent:

Connection string type:Oracle
Connection string:Data Source=MyOracleDB;OSAuthent=1;

Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.

ODBC Driver for Oracle

For the current Oracle ODBC driver from Microsoft:

Connection string type:ODBC
Connection string:Driver={Microsoft ODBC for Oracle};Server=OracleServer.world; Uid=MyUsername;Pwd=MyPassword;

For the older Oracle ODBC driver from Microsoft:

Connection string type:ODBC
Connection string:Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;

OLE DB Provider for Oracle (from Oracle).

For Standard security:

Connection string type:OleDb
Connection string:Provider=OraOLEDB.Oracle;Data Source=MyOracleDB; User Id=myUsername;Password=myPassword;/td>

For a Trusted connection:

OS Authenticated connect setting user ID to "/":

Connection string type:OleDb
Connection string:Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=/;Password=;

OS Authenticated connect using OSAuthent:

Connection string type:OleDb
Connection string:Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;

Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.

More information