none
The code works from console app and not from web page on same web development machine. using oracle ODP.Net. RRS feed

  • Question

  •  

    Machine : windows 7 64 bit

    Visual studio 2013 update 3

    ODP.NET client 10.2.0.221

    The below code executes only when run as console application. If run as web application it gives error. Connection opens without any error from console application. Both are set to .net 4 and x86 mode. 

    {"ORA-6413: Connection not open."} System.Exception {Oracle.DataAccess.Client.OracleExcepti


    string conn = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx)(PORT=1521))(CONNECT_DATA=(SID=BAANWIX))); User Id=xxxx;Password=xxxx;";
                using (OracleConnection cn = new OracleConnection(conn))
                {
                    try
                    {
                        cn.Open();
                    }
                    catch (Exception ex)
                    {
                        Console.Write(ex.ToString());
                    }
                    finally
                    {
                        cn.Close();
                    }
                }



    VM

    • Moved by Amanda Zhu Thursday, October 30, 2014 7:07 AM
    Wednesday, October 29, 2014 8:44 PM

All replies

  • Hello VeeMat,

    Thank you for your post.

    Your issue is out of support range of VS General Question forum which mainly discusses the usage issue of Visual Studio IDE such as WPF & SL designer, Visual Studio Guidance Automation Toolkit, Developer Documentation and Help System and Visual Studio Editor.

    Because your issue is relate to Oracel database’s usage in ASP.NET with ODP.Net, I suggest consulting your issue on ODP.NET community: ODP.NET Discussion Forum for better support.

    Thanks,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, October 30, 2014 7:06 AM