This content has been marked as final. Show 4 replies
Microsoft doesnt make a 64 bit ODBC driver or OLEDB provider for Oracle. Your choices would be:
1) run the app as 32 bit instead.
Configuring IIS to Run 32-bit Applications on 64-bit Windows (IIS 6.0)
2) install 64 bit Oracle ODBC driver or Oracle OLEDB provider instead, and run the app as 64 bit.
Note that on 2008R2, the only supported versions currently are 10205, 11201, and 11202.
Hope it helps,
Hi, thanks for your help.
I try your suggestions 1 and 2 but I don't resolve... sorry...
In the Administrative Tools ---> Data Source ODBC I have Oracle in instantclient_11_2, but I try the configuration I have this error:
«Unable to connect SQLState=08004 [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified»
If I try connection for Navicat Premium it's all OK... :(
I had the same problem and solved it by following these steps:
--the second step suggested earlier by gdarling
-- Install the Oracle Client for 64bits Systems; (win64_11gR1_client)
-- Make connection using this ConnectionString:
"Provider=OraOLEDB.Oracle.1;Password=XXXX;Persist Security Info=True;User ID=XXXX;Data Source=XXXX"
Thanks! The connectionstring in your answer solved my issue (which I was searching already for several hours)
Why has this been changed?
Before (= 32bit) I used as connectionstring (Provider=MSDAORA;....)
Using this connectionstring in 64bit was working for the connection only, once I tried to perform a select, the select returned me all the time "Invalid ROWID".