Creating report with a universe connected to MS Access

building reports webintelligence
1

We’re running BOXIr2 on UNIX.

I have a Universe for wich I created a connection using an ODBC to a MS Access database.

I see my tables etc.
I exported the universe to the CMS. (Which is on Oracle)

I tried to create a webi report using the universe but I can’t refresh my DP

I get the old
An internal error occurred while calling the ‘processDPCommands’ API. (Error: WIS 30270)

Any idea???
:hb:
doc3.doc (48.0 KB)

dlabine :us: (BOB member since 2005-10-31)

2

Do you have ODBC drivers set up on your UNIX server?

DJ

DJ06482 :us: (BOB member since 2002-11-22)

3

I am not sure if it an absolute necessity, but I have got in the habit of keeping the MS Access db stored locally on the Web Intelligence Server. I have not had good luck with accessing MS access databases across the network and reporting against it with Webi.

You do not need MS Access installed on the server, just the database file.

Now, you are using UNIX which may throw another variable into it.

tkdrocks :us: (BOB member since 2003-06-10)

4

i m able to run the queries in full client but not in WEBI it is giving me the same error as someone had written above.
can u tell how to install MS access database on the server…
is it something to change with the log files…

DataGenius (BOB member since 2006-06-13)

5

Can u please tell how to place the MS Access file on the server…
or any other solution so that i can run my query in webi

DataGenius (BOB member since 2006-06-13)

6

I’d recommend just migrating your database to Oracle. The other option is you could use something like the OpenRDA ODBC Driver which will allow you to connect to Access Databases.

I hope this helps.

-Mael 8)

Ma3lst0rm (BOB member since 2006-06-05)

7

Here is something you might be interested if you don’t know how to migrate your tables manually if you later choose to do so.

http://www.oracle.com/technology/tech/migration/workbench/index.html

Ma3lst0rm (BOB member since 2006-06-05)

8

When we have had occasion to do this (in Windows), it is a simple move using Windows Explorer copying a file from one server to another. We have even written some code to automate this. I would imagine the same could be done in UNIX.

tkdrocks :us: (BOB member since 2003-06-10)

9

@ dlabine,

Hopefully you can help me by answering the following questions:
Information: I have Windows XP

How did you make a ODBC to a MS Access database?
Could you please tell me how you created a Universe in BO XI?

And how did you export the universe to the CMS (oracle)
Did you use Oracle Warehousebuilder?

When installing BO XI i can not find my MS Access database?

Please help me

Kind regards

Swimmer :netherlands: (BOB member since 2006-08-23)

10

Hi Swimmer,
To create a ODBC with Excel we need to choose Generic/Generic ODBC Datasource/ODBC Drivers.
This will allow us to use Excel dsn as input for universe creation.
Cheers
-Arpan

arpan :us: (BOB member since 2006-03-22)