Why invalid argument when connecting to an OracleDatabase ?

[Wolfgang Meister]

From a CSharp program I would like to connect to an OracleDatabase
with thefollowing code:

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;
....

string connectionstring = "User Id=peterm;Password=mypasswd;Data Source=XE;";
OracleConnection connection = new OracleConnection(connectionstring);
connection.Open();

In the Open() command I am getting an erro back:
ORA-12532 TNS invalid argument.

Why ?

I am absolute sure that I entered the correct login name and password.
So it must be either the Data Source argument or the syntax of the conntionstring.

I am using the Oracle Express version and the default database name is "XE".

So what else can be the error ?

When I define an ODBC Data Source TestOracle and connect with the following string:

string connectionstring = "User Id=peterm;Password=mypasswd;Data Source=TestOracle;";

I am getting an "ORA-12154 TNS connect could not resolved".
What's wrong with this ?

Wolfgang

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Wolfgang Meister wrote:

From a CSharp program I would like to connect to an OracleDatabase
with thefollowing code:

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;
...

string connectionstring = "User Id=peterm;Password=mypasswd;Data Source=XE;";
OracleConnection connection = new OracleConnection(connectionstring);
connection.Open();

In the Open() command I am getting an erro back:
ORA-12532 TNS invalid argument.

Why ?

I am absolute sure that I entered the correct login name and password.
So it must be either the Data Source argument or the syntax of the conntionstring.

I am using the Oracle Express version and the default database name is "XE".

So what else can be the error ?

When I define an ODBC Data Source TestOracle and connect with the following string:

string connectionstring = "User Id=peterm;Password=mypasswd;Data Source=TestOracle;";

I am getting an "ORA-12154 TNS connect could not resolved".
What's wrong with this ?

What do you have in tnsnames.ora ?

Arne

[Mr. Arnold]

"Wolfgang Meister" <wm******@hotmail.comwrote in message
news:46***********************@newsspool4.arcor-online.net...

From a CSharp program I would like to connect to an OracleDatabase
with thefollowing code:

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;
...

string connectionstring = "User Id=peterm;Password=mypasswd;Data
Source=XE;";
OracleConnection connection = new OracleConnection(connectionstring);
connection.Open();

In the Open() command I am getting an erro back:
ORA-12532 TNS invalid argument.

Why ?

I am absolute sure that I entered the correct login name and password.
So it must be either the Data Source argument or the syntax of the
conntionstring.

I am using the Oracle Express version and the default database name is
"XE".

So what else can be the error ?

When I define an ODBC Data Source TestOracle and connect with the
following string:

string connectionstring = "User Id=peterm;Password=mypasswd;Data
Source=TestOracle;";

I am getting an "ORA-12154 TNS connect could not resolved".
What's wrong with this ?

Wolfgang

[Mr. Arnold]

"Wolfgang Meister" <wm******@hotmail.comwrote in message
news:46***********************@newsspool4.arcor-online.net...

From a CSharp program I would like to connect to an OracleDatabase
with thefollowing code:

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;
...

string connectionstring = "User Id=peterm;Password=mypasswd;Data
Source=XE;";
OracleConnection connection = new OracleConnection(connectionstring);
connection.Open();

In the Open() command I am getting an erro back:
ORA-12532 TNS invalid argument.

Why ?

I am absolute sure that I entered the correct login name and password.
So it must be either the Data Source argument or the syntax of the
conntionstring.

I am using the Oracle Express version and the default database name is
"XE".

So what else can be the error ?

When I define an ODBC Data Source TestOracle and connect with the
following string:

string connectionstring = "User Id=peterm;Password=mypasswd;Data
Source=TestOracle;";

I am getting an "ORA-12154 TNS connect could not resolved".
What's wrong with this ?

Oracle is tricky. If you're doing a try/catch, then look at the Exception
InnerText messages, which may give you the exact cause of the error. That's
where I had to go in order to see what Oracle was barking about.