This content has been marked as final. Show 7 replies
Which version of the Oracle Instant client are you using? 11.1 or 11.2? Are you using a 32 bit or 64 Bit Oracle client and thereby Oracle driver?1 person found this helpful
Do you have SP1 on this Windows 7?
Can you make a SQLPLus connection to DB?
When you do TNSPING or SQLPLUS w/o any parameters, what version does it tell you?
Is this a custom Acess DB or for an APP? If the latter, are there other parameters needed by the vendor? NLS_LANG, etc.
Hi MarkM73, did you find a solution for this problem? Did VolsFan proposals help you?
Edited by: user1119285 on 27.06.2012 02:55
Edited by: user1119285 on 27.06.2012 02:56
yes I solved the problem! If you like to use the oracle ODBC-Driver on a windows 7 64bit machine, you have to choose the 11.x. version of the driver. It seems that the 10.X. versiones doesnt work with win7 64bit (full client gives message, instant client only cryptic error-messages!). The 11.x. version works fine with my oracle 10 database.
The second thing is to choose the right version of the 11.x. ODBC driver. For 32bit Office 2010 choose the 32bit ODBC-driver, for 64bit Office 2010 choose the 64bit ODBC-driver. Then everything should work fine.
Hope this helps.
Thanks for the reply. I have MS Access 2010 32 bit on a Windows 7 64 System. Also Oracle Client 11.2 is installed. When I create an ODBC DSN with C:\Windows\System32\odbcad32.exe to Oracle i can check the connection there sucessfully. When i open MS Access and try to connect to that DSN by External Data... ODBC-Database... Link to.. i get following error (german language OS):
+[Microsoft][ODBC Driver Manager] Der angegebene DSN weist eine nicht übereinstimmende Architektur von Treiber und Anwendung auf. (#0)+
With "C:\Windows\System32\odbcad32.exe" you will open the 64Bit ODBC-admin! Try "C:\Windows\SysWOW64\odbcad32.exe" to open the 32bit ODBC-admin and create an DSN connection.
I think (or hope?) this should work - sorry but I am not an expert ;).
Edited by: MarkM73 on 27.06.2012 15:27
ooh, I thought it would be contrary, but you are right. Thanks!
Yes, the name of the folder is very confusing..... It takes a long time for me to understand this....