I am having a problem in connecting the oracle database to Visual Studio. Here i am describing what I have installed and what I have did for setup environment.
OS: Windows 7 Professional SP1 64 bit Visual Studio 2010 Professional with SP1 Oracle Database is on another server : Oracle 10g 64 bit Oracle Client installed on my machine : Oracle 10g Client 32-bit Checked connection through sqlplus : Connected Done tnsping in command prompt it is pinging tnsname. Checked path in environment variable it is: Path ='C:\Oracle\product.....\bin;.......etc'
My Connection String is:
Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.x.xxx)(PORT = 1521))) (CONNECT_DATA =(SERVICE_NAME = xxxx)));User ID=xxxx;Password=xxxxxx
My Code is:
using (OracleConnection con = ...
Go to the complete details ...