#HOW TO USE MS ACCESS RUNTIME 2010 DRIVER#
HOWEVER, if you have the 32-bit Oracle Client then you MUST use the 32-bit ODBC Driver Manager from C:\WINDOWS\SYSWOW64\odbcad32.exe, NOT the one in the Control Panel in Windows 7.Value: either x86 (meaning 32-bit, go figure!) or 圆4 (64-bit) Registry path: HKEY_LOCAL_MACHINE\Software\Microsoft\Office\14.0\Outlook You can determine the bitness of Access (or the whole of Office, really) from this registry key (see ):.In other words, if you have 32-bit Access you need the 32-bit Oracle Client, and if you have 64-bit Access you need the 64-bit Oracle Client.
The bitness of the Oracle client must match the bitness of Access, not the bitness of Windows.I learned from various places to make it work was this: This had previously been working on my old computer running Access 2007 and Windows XP, but my new computer has Access 2010 and Windows 7. I had a similar problem over the last 2 days getting MS Access 2010 to access an Oracle database. Have you been able to test the connection to Oracle successfully by setting up a DSN in the ODBC Administrator? Search the file for the error number or just the word error and see what you find. Launch Access and try to connect to Oracle, then turn off the tracing and open the resulting SQL.log file. Back in the ODBC Administrator, you could try turning on ODBC tracing to see if you can find more information on the error. What is the bitness of Windows and Access and the Oracle client tools on these 2 PCs (x86 or 圆4)?ĥ. What version of Oracle are you connecting to and what Oracle driver version are you using?Ĥ. If you need to launch the 32bit ODBC administrator on a 64bit OS, launch it from c:\windows\syswow64\odbcad32.exe.ģ.
#HOW TO USE MS ACCESS RUNTIME 2010 DRIVERS#
Tools > Data Sources (ODBC)) and selecting the drivers tab. Does the driver version match that of the working PC? You can verify this by going to the ODBC administrator (Start > Control Panel > Administrative
Have you installed the Oracle ODBC driver on this machine?Ģ. On the Oracle setup on this second machine.ġ. I would first verify that both machines have the same service packs applied for Windows and Office to eliminate concerns in that area.
0 kommentar(er)
