No ODBC Drivers available for Excel or Access in Windows 7 ?!

Anonymous
2009-10-08T06:27:39+00:00

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: "To 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!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2010-02-16T06:07:57+00:00

I think the answer is already here in this thread (but it's not, imo, the post marked as "Answer").

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.

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: https://sourceforge.net/projects/mondrian/. Tomcat, mondrian, edits to config files to point things in the right direction, etc.

But given that it all now works, I'd say that the ODBC connection to the Access db must be working (I'm getting its data in the web interface to Mondrian).  Mondrian is an open-source (sourceforge) OLAP project.  It's also bundled with other BI stuff at: www.pentaho.com

The default data store for Mondrian on Windows is Access.

So the key is to use c:\windows\sysWOW64\odbcad32.exe

Was this answer helpful?

90+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2012-07-03T21:51:52+00:00

The following KB article provides additional information on how to create DSNs that make use of Office ODBC drivers on 64 bit versions of Windows.

2721825          Unable to create DSN for Microsoft Office System Driver on 64-bit versions of Windows

http://support.microsoft.com/kb/2721825/EN-US

Hopefully this helps.

Best Regards,

Nathan O.

Microsoft Online Community Support

Was this answer helpful?

30+ people found this answer helpful.
0 comments

83 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-03-18T15:40:30+00:00

    In addition to configuring odbcad32.exe from SysWOW64 folder as mentioned above, if someone is using Visual Studio 2008 over Window 7 x64,  open the project properties, select

    Build options, and change Platform Target to be "x86".  

    I was having the following exception while trying to Open the odbc connection by using the Open method from OdbcConnection from C# .NET:

    {"ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"}

    That exception was gone once the Platform Target is changed to "x86".

    I think the reason is because we are using 32 bit version of the Access driver, but Visual Studio is compiling to x64 platform by default, that causes an architecture mismatch,

    we need to compile the project to 32 bit version in order to use corresponding 32 bit ODBC driver.

    I hope that helps other people.

    Regards,

    Silverio

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-03-18T10:45:24+00:00

    Dear,

    I followed the procedure as mentioned above? Unfortunately, without any luck.

    Our database is MaxDb

    I have a windows 7 machine with access 2007.

    Thanks to the above procedure, I can select the "SAP Db driver" (version 7.04.03.00)  but each time i'd like to create a "system-dsn" I receive following error:

    "This application uses CTL3D32.dll, which has not been correctly installed. CTL3D32.dll must be installed in the windows directory".

    When I click on OK, I can continue with the procedure in order to create a datasource.

    Nevertheless, once I launch access and open the ODBC-database, I obtain an empty 'tables box'.

    So, I started to search the internet for a solution.

    Unfortunately, no solution found.

    Downloading the corresponding dll-file in order to overwrite the existing one is something someone told me 'not to be done'.

    Conclusion: Is there anyone who can help me with this problem? 

    Info: I'm no expert + it's a small company without an ICT'er ;-) but i'd like to install this one on my own.

    Thanks

    Gm

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-02-27T21:04:43+00:00

    The complete solution is:

    1. Download/run mdac_typ.exe (MDAC 2.8) from http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en. This will provide all the 32-bit ODBC drivers you are looking for. There's no need to install/re-install/modify MS Access.
    2. Then use the 32-bit version of ODBC: c:\windows\sysWOW64\odbcad32.exe. You may make a shortcut of it on your desktop to remember its location later on. The Data Sources (ODBC) control panel applet on a 64-bit system will only list 64-bit drivers.

    Was this answer helpful?

    0 comments