OBDC connection with Oracle on a 64 bits Windows 7
Posted: Wed Oct 12, 2011 2:35 pm
Hello,
We successfully connect to our Oracle db through our Ranorex installed on a Windows XP machine.
Somehow it doesn't work with my Ranorex on Windows 7, 64 bits, using the same code, same data source. I verified my odbc connection with my odbc config tools in Windows 7 and it worked... I checked every little conf for my datasource and they are the same...
Here is my C# code I used in Ranorex
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
"Driver=MSDAORA;" +
"Data Source=IBZQA;" +
"User id=*****;" +
"PROVIDER=MSDAORA;" +
"Password=******;";
conn.Open()
I have this ORACLE ERROR at connection time:
ORA-12154: TNS:could not resolve the connect identifier specified
Michel
We successfully connect to our Oracle db through our Ranorex installed on a Windows XP machine.
Somehow it doesn't work with my Ranorex on Windows 7, 64 bits, using the same code, same data source. I verified my odbc connection with my odbc config tools in Windows 7 and it worked... I checked every little conf for my datasource and they are the same...
Here is my C# code I used in Ranorex
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
"Driver=MSDAORA;" +
"Data Source=IBZQA;" +
"User id=*****;" +
"PROVIDER=MSDAORA;" +
"Password=******;";
conn.Open()
I have this ORACLE ERROR at connection time:
ORA-12154: TNS:could not resolve the connect identifier specified
Michel