If you want to connect to Oracle from Visual Studio 2008 Server Explorer, follow the below steps.
Install ODP.Net from Oracle (latest version)
While installing, make sure client bits are installed
After installation, add the following Enviroment variable
TNS_ADMIN pointing to the folder containing TNSNAMES.ORA
If there is no existing Oracle home, then copy TNSNAMES.ORA sample from Network/Admin/Samples folder and modify to your needs.
That's it.
Happy Programming....
No comments:
Post a Comment