Oracle error with VC#.NET application -- help needed

Question

1.00/5 (1 vote)

See more:

.NET2.0

, +

Hi,

I have a .NET application that was working on my machine earlier , I tried to install an application that was working with previous version of Oracle , i have now unistalled this application but now my application fails with below mentioned error:-

After searching i found it might be due to two versions of oci.dll being present , is searched for it , and there was a mapped network drive having previous version and also path in env variables. I have disconected that drive and also removed that path from env variables. I have also uninstalled and installed Oracle Network Client again.

I am working on Windows 7 and using VS2005 .

I am stuck for 2 days with it ,
thanks for help in advance .

Thanks and Regards,
Shreyas

OCIEnvCreate failed with return code -1 but error message text was not available.
  
at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
   at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoLoadDataSet(DBCommandWrapper command, DataSet dataSet, String[] tableNames)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DBCommandWrapper command, DataSet dataSet, String[] tableNames)
   at Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.LoadDataSet(DBCommandWrapper commandWrapper, DataSet dataSet, String[] tableNames)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DBCommandWrapper command, DataSet dataSet, String tableName)

Posted 18-May-13 21:05pm

srastogi85

Updated 19-May-13 2:25am

Abhishek Pant

v2

Add a Solution

Comments

walterhevedeich 23-May-13 3:30am

Looks like the only thing you can do is to revert to whatever configuration it was when the application was working.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 10073643 · Answer 1 · 2013-05-24T06:58:00

Solution 1

Is your Windows 7 32-bit or 64-bit? Oracle has separate drivers for each, and if you've only re-installed the 64-bit drivers, 32-bit apps still won't work.

Posted 24-May-13 6:58am

Member 10073643

srastogi85 · Answer 2 · 2013-05-24T08:29:00

Hi,

I was able to solve it help of my friend.
When we unsinstall aind install a new version of OracleClient it takes a backup of old registry entries and creates new registry entries, so your oracle client starts pointing to a new path.
When you install back it installs but registry entried point to a new path

So evrytime you need to uninstall / install Oracle Client you need to take care of registry entries as well.
I renamed it back old folder in Registry to Oracle it started working