Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Data provider internal error(-3000) w/ ODP.NET

422058May 25 2004 — edited Nov 24 2004
I'm seeing the following error appear on an application recently upgraded to the Oracle Provider for .NET (from the MS provider):

Data provider internal error(-3000)
Exception Details: Oracle.DataAccess.Client.OracleException: Data provider internal error(-3000)

This error appears when I try and open a DataReader: myReader = adoCmd.ExecuteReader();

What's surprising is that this error occurs only on our test server. I have the same software configuration installed on my local system, and see no errors. However, there's one major config difference between my local system and the server- the server runs Oracle on a second volume, on drive D:, while my local system has everything installed on C:.

Any ideas?

Comments

417657
Update ODP.NET to 9.2.0.4
422058
Thanks- our DBA reinstalled the Oracle .NET Provider and the issue is now resolved. (Lesson: don't let a developer like me install anything Oracle-related on your servers)...
133763
We are experiencing odp.net 3000 errors:

DB:9.2.0.4.0
odp.net: 9.2.0.4.01 w/3095277 patch installed
client: 9.2.0.1 9ir2 patch set 9.2.0.4.0


Receiving 'Oracle.DataAccess.Client.OracleException Data provider internal error(-3000)' on Middle-tier connections started at 10:30am this morning occurring continuously

Oracle.DataAccess.Client.OracleException Data provider internal error(-3000)
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery,
Boolean fillRequest, CommandBehavior behavior)
at
Oracle.DataAccess.Client.OracleCommand.System.Data.IDbCommand.ExecuteReader()
System.InvalidOperationException: Transaction could not be started. --->
Oracle.DataAccess.Client.OracleException Data provider internal error(-3000)
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure)
at Oracle.DataAccess.Client.OracleTransaction..ctor(OracleConnection
connection, IsolationLevel isolationLevel, Int32 txnHndAllocated)
at Oracle.DataAccess.Client.OracleConnection.BeginTransaction()
at
Oracle.DataAccess.Client.OracleConnection.System.Data.IDbConnection.BeginTransac
tion()


Oracle.DataAccess.Client.OracleException Data provider internal error(-3001)
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery,
Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)


Oracle.DataAccess.Client.OracleException Data provider internal error(-3000)
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()


Any suggestions?

thanks
K.P.Singh

kpsingh@ohiosavings.com
320111
Use the \Microsoft.NET\Framework\v1.1.4322\System.Data.OracleClient.dll from Microsoft instead. This error will never go away and crashes our intranet server daily.
133763
I saw your response about the 3000 errors.
Can you expand little bit more on that?

thanks

kpsingh@ohiosavings.com

216-588-3144

Greatly appreciate your response
320111
Install a basic Oracle client (ODP not required) 8i or above and then use code from the following documentation:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoracleclient.asp
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 22 2004
Added on May 25 2004
6 comments
1,689 views