0 Replies Latest reply on Jul 25, 2013 1:05 PM by Achala

    OBIEE 11g - how to create MS Access DSN


      Dear All,


      I have checked the below discussion for help, but its not completely answered

      MS Access Database connection from OBIEE 11g



      My issue:

      I have installed OBIEE 11g recently, and I want to import an MS Access DB on to my 11g RPD.

      I tried creating DSN using the ODBC Data Source Administrator located at this Path:


      using the Microsoft Access Driver(*.mdb)

      But when i try to import in the RPD, I do not see this DSN listed!


      the RPD shows only DSN's available in the ODBC Data Source Administrator available at this path:



      When I try to create a DSN at this Path (C:\Windows\System32) I did not find the  Microsoft Access Driver(*.mdb) driver.

      1. Can you please help me with how I can get this driver on (C:\Windows\System32)  OR

      2. If there is way to point RPD to import using DSN at C:\Windows\SysWOW64 OR

      3. or any other workaround?


      Please help me. This is urgent.


      Thanks in advance.