BusinessObjects Board

Access DB Reports

WIS 10901

Getting this error when I try to run/create a report in WEBI based on an Access DB universe.

We have several of these, strangely some database universes work and some do not… :?

Any Idea’s?


MichaelRo1 (BOB member since 2004-05-11)

Hi,
This is the error that the data base generates check the sql of the report
Regards,
Kumar


kumar446 :india: (BOB member since 2006-01-23)

SQL is fine, I’ve tested it with only 1 field from 1 table and the error still appears…


MichaelRo1 (BOB member since 2004-05-11)

can you be more specific about the error what is the error_db number or message you are getting


kumar446 :india: (BOB member since 2006-01-23)

Getting 2 different errors depending on if I access a current db or a newly set up 1.

Current DB Error:

Database error: [Microsoft][ODBC Microsoft Access Driver]
The microsoft jet database engine could not find the input table or query ‘DATA’. Make sure it exists and that its name is spelled correctly. Contact your Business Objects administrator or database supplier for more information (Error: WIS 10901)

New DB Error:

Database error: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified.
Contact your Business Objects administrator or database supplier for more information (Error: WIS 10901)

The new DB is an copy of a working DB set up with a new ODBC connection in exactly the same way.

I can’t see any difference between the working DB’s and the ones that don’t work…


MichaelRo1 (BOB member since 2004-05-11)