What do I have to write in OracleConnectio n string for "Data Source" ?

[Werner Sammer]

I tried to connect to an existing Oracle Database with the following ConnectionStrin g:

using System.Data.Ora cleClient; // + Added Reference "System.Data.Or acleClient"

string cs = "Data Source=XE;User Id=karl;Passwor d=mypasswd";
connection = new OracleConnectio n(cs);
connection.Open ();

This code yields an "Invalid argument" ORA-12532 error.

Why ?

Even when I switch to

using Oracle.DataAcce ss.Client; // + Added Reference "Oracle.DataAcc ess"

I got the same error.

"XE" is the name of the Oracle Express Database.

What else can I do ?
Does the sequence of Data Source, User Id and Password in the connection string matter ?

Do I have to declare the "Data Source" somewhere else (beside the Reference)?

Werner

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Check http://www.connectionstrings.com/

"Werner Sammer" <we****@yahoo.d ewrote in message
news:46******** *************** @newsspool3.arc or-online.net...

>I tried to connect to an existing Oracle Database with the following
ConnectionStri ng:

using System.Data.Ora cleClient; // + Added Reference
"System.Data.Or acleClient"

string cs = "Data Source=XE;User Id=karl;Passwor d=mypasswd";
connection = new OracleConnectio n(cs);
connection.Open ();

This code yields an "Invalid argument" ORA-12532 error.

Why ?

Even when I switch to

using Oracle.DataAcce ss.Client; // + Added Reference "Oracle.DataAcc ess"

I got the same error.

"XE" is the name of the Oracle Express Database.

What else can I do ?
Does the sequence of Data Source, User Id and Password in the connection
string matter ?

Do I have to declare the "Data Source" somewhere else (beside the
Reference)?

Werner

[James Irvine]

Werner Sammer wrote:

I tried to connect to an existing Oracle Database with the following ConnectionStrin g:

using System.Data.Ora cleClient; // + Added Reference "System.Data.Or acleClient"

string cs = "Data Source=XE;User Id=karl;Passwor d=mypasswd";
connection = new OracleConnectio n(cs);
connection.Open ();

This code yields an "Invalid argument" ORA-12532 error.

Why ?

Even when I switch to

using Oracle.DataAcce ss.Client; // + Added Reference "Oracle.DataAcc ess"

I got the same error.

"XE" is the name of the Oracle Express Database.

What else can I do ?
Does the sequence of Data Source, User Id and Password in the connection string matter ?

Do I have to declare the "Data Source" somewhere else (beside the Reference)?

Werner

1. in web.config:

<connectionStri ngs>
<add name="jamieOrac le" connectionStrin g="user
id=jamie;passwo rd=jamie;data
source=(DESCRIP TION=(ADDRESS=( PROTOCOL=tcp)(H OST=jamieamd)(P ORT=1521))(CONN ECT_DATA=(SERVI CE_NAME=jamie)) )"/>
</connectionStrin gs>

2. in your app:

// create an Oracle data provider connection:
string connStr =
ConfigurationMa nager.Connectio nStrings["jamieOracl e"].ConnectionStri ng;
OracleConnectio n con = new OracleConnectio n(connStr);