OBDC connection with Oracle on a 64 bits Windows 7

Class library usage, coding and language questions.
mlabrie
Posts: 2
Joined: Mon May 02, 2011 3:20 pm

OBDC connection with Oracle on a 64 bits Windows 7

Post by mlabrie » 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

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: OBDC connection with Oracle on a 64 bits Windows 7

Post by Support Team » Wed Oct 12, 2011 3:02 pm

Hi,
mlabrie wrote:I have this ORACLE ERROR at connection time:
ORA-12154: TNS:could not resolve the connect identifier specified
It seems that you are missing the 64-Bit OLEDB Provider for ODBC (MSDASQL)
http://blogs.msdn.com/b/dataaccesstechn ... racle.aspx
Therefore please take a look to the above link.

Regards,
Peter
Ranorex Team
.
Image