Tuesday, 22 September 2015

ORA:06413 Connection not Open


  • This blog is for those who want to connect Visual Studio with Oracle Database 10g or lower upto 9i.
  • I seen there are lots of problem while connecting the Visual Studio with the Oracle 10g and 9i.
  • I would like to share that Oracle has already left the support for the same & so as the patch for connection.
  • Then instead of using Oracle 10g or 9i client for connection with Oracle Server use the client for which Oracle Corporation use to give support. 
  • I had the same problem , all code and path variable were  checked and  were perfect. But then also Client was not connecting to oracle 10g Server.
  • Even though from SQL PLUS  it was connected. 
  • Thereafter I just uninstalled Oracle 10g client and installed Oracle 11g R2 32-bit and placed tns file in ADMIN folder of OracleHome. 
  • I checked once again from VS 2010 and VS 2012 and executed code. The server was connected. 

For any query you may comment . Yours comments would be appreciated.

No comments:

Post a Comment

How To Pass An Array As A Parameter While Calling an ASP.NET Web API C#

Please visit my C# Corner Blog for this, where I have provided better efforts to make this concept more understandable - www.c-sharpcorner....