|
This is a compiled connection strings reference list on how to connect to Oracle. |
|
|
|
|
| |
Driver=
{Microsoft ODBC for Oracle};
Server=
myServerAddress;
Uid=
myUsername;
Pwd=
myPassword;
| |
| |
|
| |
Driver=
{Microsoft ODBC Driver for Oracle};
ConnectString=
OracleServer.world;
Uid=
myUsername;
Pwd=
myPassword;
| |
| |
|
|
|
This connection string uses a provider from Microsoft. | |
Provider=
msdaora;
Data Source=
MyOracleDB;
User Id=
myUsername;
Password=
myPassword;
| |
| |
|
| |
Provider=
msdaora;
Data Source=
MyOracleDB;
Persist Security Info=
False;
Integrated Security=
Yes;
| |
| |
|
This connection string uses a provider from Oracle. | |
Provider=
OraOLEDB.Oracle;
Data Source=
MyOracleDB;
User Id=
myUsername;
Password=
myPassword;
| |
| |
|
| |
Provider=
OraOLEDB.Oracle;
Data Source=
MyOracleDB;
OSAuthent=
1;
| |
| |
|
|
|
| |
Data Source=
TORCL;
User Id=
myUsername;
Password=
myPassword;
| |
| |
|
| |
Data Source=
TORCL;
Integrated Security=
SSPI;
| |
| |
|
| |
Data Source=
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));
User Id=
myUsername;
Password=
myPassword;
| |
| |
|
|
|
| |
Data Source=
MyOracleDB;
Integrated Security=
yes;
| |
This one works only with Oracle 8i release 3 or later | | |
|
| |
Data Source=
MyOracleDB;
User Id=
myUsername;
Password=
myPassword;
Integrated Security=
no;
| |
| |
|
This is another type of Oracle connection string that doesn't rely on you to have a DSN for the connection. You create a connection string based on the format used in the tnsnames.ora file without the need to actually have one of these files on the client pc. | |
SERVER=
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
uid=
myUsername;
pwd=
myPassword;
| |
| |
|
Some reported problems with the one above and Visual Studio. Use the next one if you've encountered problems. | |
Data Source=
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
User Id=
myUsername;
Password=
myPassword;
| |
| |
|
The connection pooling service will create a new pool if it can't find any existing pool that exactly match the new connections connection string properties. If there is a matching pool a connection will be recycled from that pool. | |
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;
| |
| |
|
| |
Data Source=
myOracleDB;
User Id=
/;
| |
| |
|
With SYSDBA privileges | |
Data Source=
myOracleDB;
User Id=
SYS;
Password=
SYS;
DBA Privilege=
SYSDBA;
| |
| |
|
With SYSOPER privileges | |
Data Source=
myOracleDB;
User Id=
SYS;
Password=
SYS;
DBA Privilege=
SYSOPER;
| |
| |
|
First open a connection with a connection string. When the connection is opened, an error is raised because the password have expired. Catch the error and execute the OpenWithNewPassword command supplying the new password. | |
Data Source=
myOracleDB;
User Id=
myUsername;
Password=
myPassword;
oConn.OpenWithNewPassword(sTheNewPassword);
| |
| |
|
| |
Data Source=
myOracleDB;
User Id=
myUsername;
Password=
myPassword;
Proxy User Id=
pUserId;
Proxy Password=
pPassword;
| |
| |
|
|
|
| |
User ID=
myUsername;
Password=
myPassword;
Host=
ora;
Pooling=
true;
Min Pool Size=
0;
Max Pool Size=
100;
Connection Lifetime=
0;
| |
| |
|
|
|
| |
Provider=
MSDataShape.1;
Persist Security Info=
False;
Data Provider=
MSDAORA;
Data Source=
orac;
User
| |