none
ORA-06413: Connection not open RRS feed

  • Question

  • Hi all,

    I am using Oralce Client 10g 32 bit on Windows 7 64 bit to query oracle databases running on 10g and 8i servers. I am using Visual Studio 2010 and System.Data.OracleClient to talk to Oracle. When I run my website in debug, I get this error when Visual Studio tries to open connection to Oracle,  ORA-06413: Connection not open . I have also setup my website under localhost and it executes the code fine alright and returns query result but I need to debug my code. How should I resolve this error.

    I followed a similar thread but the solution did not work in my case. I created a directory with no special characters and copied System.Data.Oracleclient.dll into that directory and referenced that into my code but still got the same error.

    Please help!

    Thursday, September 30, 2010 4:44 PM

Answers

  • Under the Project...Properties, on the Web tab you can select Use IIS Web server and specify the (http address) virtual directory for your app. It's probably http://localhost/appname.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Proposed as answer by liurong luo Monday, October 4, 2010 5:02 AM
    • Marked as answer by liurong luo Thursday, October 7, 2010 6:33 AM
    Friday, October 1, 2010 12:41 PM

All replies

  • Are you using the IIS Web Server or Visual Studio Development Server?
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Thursday, September 30, 2010 5:32 PM
  • It errors in Visual Studio Development Server (debug mode) and works fine in IIS (localhost)
    Thursday, September 30, 2010 5:40 PM
  • You should be able to debug when using IIS. I'm wondering whether your app is running 64-bit when using the VS Development Server.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    Thursday, September 30, 2010 5:46 PM
  • How should I debug within IIS? I have VS 2010 32 bit.
    Thursday, September 30, 2010 6:24 PM
  • Under the Project...Properties, on the Web tab you can select Use IIS Web server and specify the (http address) virtual directory for your app. It's probably http://localhost/appname.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Proposed as answer by liurong luo Monday, October 4, 2010 5:02 AM
    • Marked as answer by liurong luo Thursday, October 7, 2010 6:33 AM
    Friday, October 1, 2010 12:41 PM