BO Webi connect to MS Access database

[Former Member]

I'm trying to use BO webi to connect to MS Access database via ODBC connection.

Here are the steps to create a connection to the Access Database.

Step #1: create a DSN for the Ms Access Database via ODBC in Control Panel

Step #2: Create Universe via IDT, to link to ODBC created

Step #3: public relational connect and business layer to BO server

Step #4: Design a report in webi

But the error message is given when running the report. "WIS 30286 You do not have access to one or more data providers; only the ones to which you have access will be refreshed. Do you want to continue?"

I have few doubts about the universe connection.

1st question: Step #1/#2/#3, should it be done in BO server or client?

2nd question: What kind of setup need to be done in the end user client if they want to run the report in webi? such as ODBC?

3rd question: the error message WIS 30286, how to resolve the error? I check the user access right in CMC, the rights have been given.

Thank you very much!

[Former Member]

If you need a 64-bit ODBC driver for Microsoft Office that supports MS Access for either Windows or Unix, you can check with SAP or download directly from the SAP OEM partner for ODBC connectors.

[mhmohammed]

Hi Jinbin,

1. Steps 1,2,3 should be done on both Server and Client, so many users can use that universe created with that MS Access DB as source.
2. Yes, ODBC as I said in answer 1.
3. You'll have to create both 32bit and 64bit ODBCs on the Server and Client.

Thanks,
Mahboob Mohammed

[Former Member]

Hi Mahboob,

Thank you very much for your reply.

1. I can understand the reason to do step #3 in both server and client. But do we need to do the step #1/#2 in the end user client also?

3. For the save data source, the name in ODBC will be different for 32bit and 64 bit. But in the IDT Relational Connection, how to connect this data source as multiple ODBC exist?