| |
ODBC Connection
String for Oracle |
| |
|
Standard Security |
| |
|
|
Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword;
|
| |
|
|
' VB.NET
Imports System.Data.Odbc
...
oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
"Dbq=myDBName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword" |
| |
|
|
|
| |
OLE
DB, OleDbConnection (.NET) Connection String for
Oracle |
| |
|
Standard Security |
| |
|
|
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
|
| |
|
|
' VB.NET
Imports System.Data.OleDb
...
oConn.Open "Provider=msdaora;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"
|
| |
|
Trusted connection |
| |
|
|
Provider=msdaora;Data Source=MyOracleDB;Persist
Security Info=False;Integrated Security=Yes;
|
| |
|
|
|
| |
OracleConnection, Oracle Data Provider, ODP.NET for
Oracle Database |
| |
|
Standard Security |
| |
|
|
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated
Security=no;
|
| |
|
|
|
| |
|
Using Connection
Pooling |
| |
|
|
Data Source=myOracleDB;User Id=myUsername;Password=myPassword;Min
Pool Size=10;Connection Lifetime=120;Connection
Timeout=60;Incr Pool Size=5;Decr Pool Size=2;
|
| |
|
|
| |
|
Windows
Authentication |
| |
|
|
Data Source=myOracleDB;User Id=/;
|
| |
|
|
|
| |
|
Privileged Connection |
| |
|
|
Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA
Privilege=SYSDBA;
|
| |
|
|
|
| |
|
|
|