Error: The connection Must Be open for this operation

Hi Expers!

Production Scenario:
Web Application made using Asp.Net 1.1 C#
Host IIS: Windows 2003 Server x86, IIS 6,
Host DB: SQL Server 2005 SP2, Oracle Database 10g Release 1

In Development Environment, Certification and Testing (3 different environments), the application works correctly.

But production is not working.

The application error occurs into a specifiable screen (which accesses an Oracle DB), displays the following error:

"The connection Must Be open for this operation" (screen attached)

I believe it is due to some problem with the Oracle DLLs.

What is better way to find a solution to this error?


Who is Participating?
slightwv (䄆 Netminder) Commented:
I know you said it runs everywhere except production but...

This error pretty much has to be because was never called.

Are you sure ALL files are copied over? Maybe there is something in the global.asax or similar config file that opens a connection and that file isn't being migrated into production?
Is that the complete stack trace?
br_msAuthor Commented:
I'm sure not a problem of code or deployment incomplete.

I believe that is caused by Oracle version of the DLLs, but I do not know how to start.

slightwv (䄆 Netminder) Commented:
Again:  Is that the complete stack trace?

I've never seen that error from a version incompatibility.  

Looks like you are using ODP.Net.  The important DLL is OracleDataAccess.dll.  Check the version between the different systems.
Protect Your Employees from Wi-Fi Threats

As Wi-Fi growth and popularity continues to climb, not everyone understands the risks that come with connecting to public Wi-Fi or even offering Wi-Fi to employees, visitors and guests. Download the resource kit to make sure your safe wherever business takes you!

Is your production and development share the same database server? If not then maybe there's something wrong in your connection string.
br_msAuthor Commented:
How exactly was this resolved? I'm having the same issue too
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.