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?
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.
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)+