ODBC Setup Problem


  1. Posts : 4
    windows 7 ultimate 64bit
       #1

    ODBC Setup Problem


    I have Win 7 Ultimate 64 bit. I have the following problem..
    when I try to install an ODBC connection (*mdb),
    Data sources ODBC > SYSTEM DSN > ADD > (here only sql server is listd, not .mdb) and also
    I get the following fault message:
    "The Microsoft Access Driver (.mdb) ODBC driver could not be found. Please reinstall the driver". i have ms access 2003.
    I need this for database connectivity with webpages. i need to solve this issue urgently...
      My Computer


  2. Posts : 4
    windows 7 ultimate 64bit
    Thread Starter
       #2

    please anyone help me ...
      My Computer


  3. Posts : 2,737
    Windows 7 Enterprise (x64); Windows Server 2008 R2 (x64)
       #3

    I think this is what you are looking for:

    Download details: Microsoft Access Database Engine 2010 Redistributable

    Let me know -WS
      My Computer


  4. Posts : 4
    windows 7 ultimate 64bit
    Thread Starter
       #4

    I download the file AccessDatabaseEngine.exe. The installation was successfull, but the problem is still there. the instructions to use this file are : ;; can u guide me what to do next?

    To use this download:
    1.If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
    2.If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
    ◦If you are connecting to Microsoft Office Excel data, add “Excel 14.0” to the Extended Properties of the OLEDB connection string.
    3.If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
    4.If you are application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
      My Computer


  5. Posts : 2,737
    Windows 7 Enterprise (x64); Windows Server 2008 R2 (x64)
       #5

    Shouldn't you have installed the "AccessDatabaseEngine_X64.exe" version?? I thought you were on 64bit??

    Edit: Maybe that is for Office 64bit?? I am Unsure?
      My Computer


  6. Posts : 4
    windows 7 ultimate 64bit
    Thread Starter
       #6

    yes i tried to install "AccessDatabaseEngine_X64.exe" version but error came that cannot install becoz office application is in 32 bit..
      My Computer


  7. Posts : 2,737
    Windows 7 Enterprise (x64); Windows Server 2008 R2 (x64)
       #7

    anorita said:
    yes i tried to install "AccessDatabaseEngine_X64.exe" version but error came that cannot install becoz office application is in 32 bit..
    I am not sure what to do from here. Let me see if I can get someone that knows more about this than me to help. -WS
      My Computer


  8. Posts : 3,009
    Windows 7 Home Premium 64bit
       #8

    Maybe some useful information here...
    ODBC--Open Database Connectivity Overview

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

    Hope this helps. :)
      My Computer


  9. Posts : 2,737
    Windows 7 Enterprise (x64); Windows Server 2008 R2 (x64)
       #9

    Ok here is something strange. On my Windows 7 Ultimate machine(s) this acts as the OP states. However on my Windows 7 Enterprise machines the options to add Access connectors are there?? I have no idea why this is?
    Attached Thumbnails Attached Thumbnails ODBC Setup Problem-odbc.png  
      My Computer


  10. Posts : 1
    Windows 7 Ultimate 64 bit
       #10

    Problem while connecting MS Access Database with OLEDB


    Hi i am facing the same problem as everybody is facing , my sir says dat its because of the OS those who r having Licensed version of windows 7 ultimate they get all the function of ms acces to connect n those who r using the pirated version have nly the SQL function so plz help me out smebody with this stuff plz gimme the link to install the driver for OLEDB ms access windows 7 ultimate 64 bit
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 01:40.
Find Us