I have checked the below discussion for help, but its not completely answered
MS Access Database connection from OBIEE 11g
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.