- 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.