5 Replies Latest reply on Oct 18, 2012 2:37 PM by xxsawer

    How to connect to a MS Access DB?

      Hi guys,

      this time I have a question how to connect to a MS Access DB?
      I have an .accdb file located somewhere on the disk. In the new connection window, I switch to Access tab, fill the Connection Name field, search for the file and click Test.
      Then I got an error message which can be translated like:
      Status : Failure -Test failed: [Microsoft][Driver manager ODBC] Source data name was not found and no default driver was given.

      Any idea what could be the problem?
      Thanks, Dan
        • 1. Re: How to connect to a MS Access DB?
          Commonly the MS Access ODBC driver is being used to access the MDB file. Do you have it installed on your machine?
          What opearting system (including word size) are you using and which MS Access ODCB driver (version and word size) is installed?
          • 2. Re: How to connect to a MS Access DB?
            thank you for quick reply and sorry for my delay...
            Well, I never cared about the driver, I suppose this should be installed defaultly in the OS.
            I am using W7 64b
            How can I find which version of MS Access ODBC driver is installed?
            I ran: %WINDIR%\SYSWOW64\odbcad32.exe
            and here are my screens

            • 3. Re: How to connect to a MS Access DB?
              Dan, syswo64 is commonly pointing to a 32bit ODBC driver - when you're using the 64bit SQlDev release on a 64bit platform you also need the 64bit ODBC drivers (and those are not installed by default). You need to get the AccessDatabaseEngine_x64.exe from MS which contains the 64bit ODBC drivers and is available here: http://www.microsoft.com/en-us/download/details.aspx?id=13255.
              • 4. Re: How to connect to a MS Access DB?
                You are right,
                If I run %WINDIR%\system32\odbcad32.exe
                then I don't see any access driver installed

                The problem is, when I try to install the 64b driver from your link, I get this error:

                This looks like a funny trap :(

                • 5. Re: How to connect to a MS Access DB?
                  Ok, so I found the solution.
                  I uninstalled the 32b MS Office and installed the 64b version. The product key was working on 64b version as well and the good thing is that the pakcage I used for installation contained the MS Access as well. So I got also trial version of Access.
                  After installation I checked the %WINDIR%\system32\odbcad32.exe again and saw that the ODBC driver is installed. So it was probably installed with MS Access.
                  The connection to the accdb file from SQL Developer is working now, perfect :)

                  I have just one more question.
                  I see that in the file are some views, but they cannot be displayed. Clicking/doubleclicking doesn't have any affect.
                  I also can't display the SQL query used for that view. I only can export the view to Excel...
                  Is there any way how to display the content of the view or the SQL query?