C#.net connection string connecting to remote Oracle database
Oracle ODBC
New version:
"Driver={microsoft ODBC for Oracle}; Server=oracleserver.world; Uid=username; PWD=ASDASD; "
Old version:
"Driver={microsoft ODBC Driver for Oracle}; Connectstring=oracleserver.world; Uid=myusername; Pwd=mypassword; "
OLE DB, OleDbConnection (. NET)
Standard Security:
"Provider=msdaora;data source= myoracledb; Userid=username; PASSWORD=ASDASD; "
This one's from Microsoft, the following are from Oracle
Standard Security:
"Provider=oraoledb.oracle;data Source=myoracledb; User Id=username; PASSWORD=ASDASD; "
Trusted Connection:
"Provider=oraoledb.oracle;data source=myoracledb;osauthent=1;"
OracleConnection (. NET)
Standard:
"Data source=oracle8i;integrated Security=yes";
This one works only with Oracle 8i Release 3 or later
Declare the OracleConnection:
C#:
Using System.Data.OracleClient;
OracleConnection ooracleconn = new OracleConnection ();
ooracleconn.connectionstring = "My ConnectionString";
Ooracleconn.open ();
References: http://www.cnblogs.com/daview/archive/2004/04/10/5763.aspx