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
OBDC connection with Oracle on a 64 bits Windows 7
- Support Team
- Site Admin
- Posts: 12145
- Joined: Fri Jul 07, 2006 4:30 pm
- Location: Houston, Texas, USA
- Contact:
Re: OBDC connection with Oracle on a 64 bits Windows 7
Hi,
http://blogs.msdn.com/b/dataaccesstechn ... racle.aspx
Therefore please take a look to the above link.
Regards,
Peter
Ranorex Team
It seems that you are missing the 64-Bit OLEDB Provider for ODBC (MSDASQL)mlabrie wrote:I have this ORACLE ERROR at connection time:
ORA-12154: TNS:could not resolve the connect identifier specified
http://blogs.msdn.com/b/dataaccesstechn ... racle.aspx
Therefore please take a look to the above link.
Regards,
Peter
Ranorex Team