Database Error while running query in Webi.

When I try to run query from Webi, I get an error of this kind:
The database error text is: {error_db}. (WIS 10901)
I'm using SQL Server 2000 DB and driver is ODBC.It is not retreiving data to the report.
Somebody please help me to resolve this issue.....

TijiKThomas
Profile Answers by TijiKThomas Questions by TijiKThomas
Nov 5th, 2008
1
10725

Questions by TijiKThomas

Business Objects

Answer

Showing Answers 1 - 1 of 1 Answers

tgmurugan
Profile Answers by tgmurugan

Sep 29th, 2009

Have you created a DSN on the server (If using SQL server) or an entry in the TNSANAMES.ORA file for Oracle?
Also make sure the ODBC connections are named exactly the same. "MS_ACCESS" is not the same as "MS_Access" when using DSNs for connections.

or redefine the odbc system connection.
or If the database is MS Access, .mdb file should be kept on Server machine.

To run DeskI reports, create a File DSN on your local machine for this .mdb file located at server and create System DSN or File DSN (should have same DSN name) on the server machine to run WebI reports.

Having same name as of DSN created on local machine will allow to run WebI reports.
or Contact your administrator or database supplier.