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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2012-01-28T12:07:57+00:00

    Hi, I had the same problem. I was trying to create a new DSN, the drivers were not there. So I kept looking for solutions, and I found one that fixed my problem. Hope It will help you too.

    You can follow this link: http://learn.iis.net/page.aspx/563/using-classic-asp-with-microsoft-access-databases-on-iis/

    or just follow the below steps.

    Working with 64-bit Systems

    Unfortunately there are no 64-bit ODBC drivers, so on 64-bit systems you will have to run your applications in 32-bit mode. To do so, use the following steps:

    1. On the taskbar, click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
    2. In the Connections pane, click Application Pools.
    3. Highlight the application pool for your application, then click Advanced Settings... in the Actions pane.
    4. In the Advanced Settings dialog, specify True for Enable 32-Bit Applications.
    5. Click OK to close the Advanced Settings dialog.

    Note: The 64-bit control panel applet for managing ODBC connections will not display 32-bit ODBC drivers. To work around this issue, you need to open the 32-bit ODBC applet. To do so, use the following steps:

    1. Click Start and then Run, or open a command prompt.
    2. Enter the following command: %windir%\syswow64\odbcad32.exe
    3. Press the enter key.

    Working with User Access Control

    You need to make sure that you follow the steps in this document by using an account that has full administrative permissions. This is best accomplished by using one of two methods:

    • Log in to your computer by using the local administrator account.
    • If you are logged in using an account that administrative permissions but that is not the local administrator account, open all applications and all command prompt sessions by using the "Run as Administrator" option.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-12-01T06:27:33+00:00

    It worked, ty.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-11-15T20:56:29+00:00

    Ok, I realize this thread is old, but still useful...

    Like others already said, the ODBC wizard is nowhere to be found if you dont know the "stone's path" (c:\windows\sysWOW64\odbcad32.exe)

    Another good point (that I think it's work to throw a dime at): if your application is 32 bits and works well on Windows XP (seems to be the case) then, find it in the start menu, right click on it to get the "properties" and set it to run in "Compatibility Mode With Service Pack XX", according to what used to work on XP.

    You will find that this cures a lot of weird things....

    Was this answer helpful?

    0 comments