asked on

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?

Thx!

error.JPG

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

br_ms

ASKER

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.

Thx.

slightwv (䄆 Netminder)

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.

drypz

Is your production and development share the same database server? If not then maybe there's something wrong in your connection string.

br_ms

ASKER

Resolved!

eagle_ea

How exactly was this resolved? I'm having the same issue too