0 Replies Latest reply: Jul 25, 2013 8:05 AM by Achala RSS

    OBIEE 11g - how to create MS Access DSN

    Achala

      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:

      C:\Windows\SysWOW64

      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:

      C:\Windows\System32

       

      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.

      Achala