ODP .NET error -3000

[Amit]

I am getting the error "Data Provider Internal Error(-3000)" while
trying to open a connection using ODP .NET. Here is the code:


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

OracleConnection con = new OracleConnection();
con.ConnectionString = "User ID=count;Password=count;Data
Source=USprd140;";
con.Open();

What could be the problem. I can connect to the database using these
credentials and also can create a DSN which connects successfully.

 

[Frans Bouma [C# MVP]]

I am getting the error "Data Provider Internal Error(-3000)" while
trying to open a connection using ODP .NET. Here is the code:


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

OracleConnection con = new OracleConnection();
con.ConnectionString = "User ID=count;Password=count;Data
Source=USprd140;";
con.Open();

What could be the problem. I can connect to the database using these
credentials and also can create a DSN which connects successfully.

Error 3000 is a 'famous' ODP.NET error, could mean anything.

The code looks ok, so you should look at other things:
1) use the 9i ODP.NET version (9.2.0.401) for 9i, not the 10g ODP.NET
version
2) set the right Oracle home as your first home (in the path) if you've
multiple homes installed, that is, the 9i ODP.NET client home as the
first home if you're connecting to 9i and the 10g home if you're
connecting to 10g (and then also use the 10g ODP.NET)
3) be sure to use official versions, not the intermediate patches like
9.2.0.415.
4) be sure not to use the beta's like 10.1.0.303

FB

--