Re: ODP .NET error -3000

Amit wrote:
> 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

-- 
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------