No ODBC Drivers available for Excel or Access! Even after a complete new installation of Windows 7 and Office 2003 professional or Office 2007 professional on another computer. When I want to add a driver in the ODBC Data Source Administrator, the response is: 'T o install new drivers use the driver's setup program!' In the ODBC Data Source Administrators Windows only the SQL-Native Client and SQL-Server, from Microsoft shows to be installed! How to install these ODBC Drivers or how to go about it? Thanks a lot for your responses! I think the answer is already here in this thread (but it's not, imo, the post marked as 'Answer').
On 64-bit Windows, you can execute 64-bit and 32-bit applications transparently. Data Source Names (DSN) are similarly divided by bitness, since a DSN is defined for a specific driver. The 32-bit version of the ODBC Data Source Administrator must be used to configure data sources for 32-bit.
You need to use Windows 7 32-bit subsystem. In particular, you need to use the ODBC control panel here: c: windows sysWOW64 odbcad32.exe At least in my case, that version (the 32 bit version) of the cpl did contain the Access (2003 in my case) ODBC driver.
The 64 bit DLLs etc are in c: windows system32. The 32 bit subsystem (so you can still run 32 bit apps on 64 bit Windows 7) is in c: windows sysWOW64. Windows 10 Realtek Hd Audio Driver. I mean, that's very intuitive - right? But I didn't post anything here until I could confirm that the 32 bit ODBC connection to Access was working (giving me the db's data). Well what I'm trying to get to work goes through a bunch more complications: Tomcat, mondrian, edits to config files to point things in the right direction, etc.
Comments are closed.