Results 1 to 8 of 8

Thread: No ODBC Drivers available for Excel or Access in Windows 7

  1. #1
    Join Date
    Mar 2010
    Posts
    183

    No ODBC Drivers available for Excel or Access in Windows 7

    I have a PC running Windows 7 Professional 64-bit application I programmed JAVA to access a database Microsoft Access. My problem is that when I want to add my database using the tools Directors data sources ODBC from windows. I had faced with an error message. It is rather normal since the list of drivers ODBC installed on my machine only SQL Server appears.

  2. #2
    Join Date
    Nov 2009
    Posts
    955

    Re: No ODBC Drivers available for Excel or Access in Windows 7

    I had just installed jre and jdk 32 bit version in addition to my 64-bit version and then I setup eclipse for netbeens they use 32-bit jdk in the folder Program Files (x86 ) instead of 64-bit jdk in the folder' Program Files. To compile 32-bit go to Project Properties and then click on compile tab. Then go to Advanced compilation and then go change Unit ventral target alongwith x86. Re-compile back again.

  3. #3
    Join Date
    Nov 2009
    Posts
    857

    Re: No ODBC Drivers available for Excel or Access in Windows 7

    One thing about it is that the solution proposed for the odbc driver to access despite handling a problem persists or the following error: the error is Microsoft.jet.OLEDB 4.0 is not registered on the local computer. To connect to the database access in a program in VB.NET SEVEN running 64-bit while under vista and xp 32-bit there is no such issue related to this.

  4. #4
    Join Date
    Jun 2009
    Posts
    1,112

    Re: No ODBC Drivers available for Excel or Access in Windows 7

    I have a similar configuration with me. I am using Windows 7 , IIS and ASP site with an Access database. I have found the management ODBC in system32 or I whether I should out the drivers but I remain at the same point. Have you added some sort of drivers for the same. I go the same error when I launch IIS. have exactly the same problem with ASP / IIS / Seven 64-bit.

  5. #5
    Join Date
    Jun 2009
    Posts
    886

    Re: No ODBC Drivers available for Excel or Access in Windows 7

    I finally found the solution is actually very simple. This solution works if the driver is installed in 32-bit (sysWOW34) and not 64-bit (system32). Go to Control Panel > System and Security > Administrative Tools > Internet Services Manager (IIS). Then go in the Connection pane, expand if necessary and then click Application Pools. After that click on DefaultAppPool and then go to Advanced Settings. Then go to General and enable 32-bit applications. choose True for that.

  6. #6
    Join Date
    Apr 2008
    Posts
    3,339

    Re: No ODBC Drivers available for Excel or Access in Windows 7

    I had installed the 32bit version of the jdk 1.6 and change the settings for my project on netbeans to use this jdk. For that you might need to use the odbc for 32bit at C: \ Windows \ SysWOW64 \ odbcad32.exe. Then you will need to configure the database as a 32bit machine. Configure IIS as saying wam in his message. You might need to download and install from the Microsoft website. Change the configuration netbeans to use version of 32bit jdk. All things work well.

  7. #7
    Join Date
    Jul 2009
    Posts
    1,179

    Re: No ODBC Drivers available for Excel or Access in Windows 7

    Search if you do not have an executable odbc on your hard drive to install ODBC drivers. A odbcad32.exe example more or less reliable information from google. I downloaded the driver (MySQL Connector ODBC 5.1) and installed in the ODBCConfig For me this is still not displayed. By default, the SQL driver is included by MS, however, does not bring me further.

  8. #8
    Join Date
    Nov 2011
    Posts
    1

    Re: No ODBC Drivers available for Excel or Access in Windows 7

    Quote Originally Posted by Paisley007 View Post
    I finally found the solution is actually very simple. This solution works if the driver is installed in 32-bit (sysWOW34) and not 64-bit (system32). Go to Control Panel > System and Security > Administrative Tools > Internet Services Manager (IIS). Then go in the Connection pane, expand if necessary and then click Application Pools. After that click on DefaultAppPool and then go to Advanced Settings. Then go to General and enable 32-bit applications. choose True for that.
    using win7,i use the command odbcad32.my pc is 32-bit.

Similar Threads

  1. ODBC drivers are missing in win 7 home premium
    By Kanesteyn in forum Windows Software
    Replies: 3
    Last Post: 28-11-2011, 04:01 PM
  2. ODBC connection to MS Excel file
    By Lakshmi.Vaidhyam in forum Software Development
    Replies: 6
    Last Post: 19-03-2011, 05:31 AM
  3. Where to get ODBC drivers in unix
    By Xylina in forum Software Development
    Replies: 5
    Last Post: 16-01-2010, 03:12 AM
  4. ODBC Drivers 64-Bit
    By NMahmoud in forum Windows Server Help
    Replies: 4
    Last Post: 13-10-2009, 01:51 PM
  5. How do I reinstall ODBC Drivers?
    By longevity in forum Windows XP Support
    Replies: 1
    Last Post: 31-12-2006, 11:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,648,372.11848 seconds with 17 queries