mbmcgra
asked on
Database Vendor Code: 904
I can run this report from CR XI but when I try to run from BO XI Enterprise I get the following error:
Failed to retrieve data from the database. Details: [Database Vendor Code: 904 ] Failed to retrieve data from the database. Error in File C:\DOCUME~1\hsg-boxi\LOCAL S~1\Temp\{ EE917AA0-4 3D7-4BC4-B 56D-FF4A67 207319}.rp t: Failed to retrieve data from the database. Details: [Database Vendor Code: 904 ]
I've changed DB drivers, and verified the DB afterwards.
I'm trying to run against an Oracle 9i DB and I'm using the ODBC (RDO) driver and I've tried the oracle driver. When changing to the oracle driver, the error message changes a little but it's essentially the same.
Failed to retrieve data from the database. Details: [Database Vendor Code: 904 ] Failed to retrieve data from the database. Error in File C:\DOCUME~1\hsg-boxi\LOCAL
I've changed DB drivers, and verified the DB afterwards.
I'm trying to run against an Oracle 9i DB and I'm using the ODBC (RDO) driver and I've tried the oracle driver. When changing to the oracle driver, the error message changes a little but it's essentially the same.
Make sure that you have all the correct permission set. This is the common problem. Are you using it through any semantic layer?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, the report runs finr from the local machine. CE prompts the users for logon info. It appears to be authenticating but after ht eparameter prompts it craps out.
ASKER
The server admin was using the CR Oracle Driver for the DSN entry. Changed it to Oracle's ODBC driver and changed the report driver to ODBC and worked.
Glad i could help
mlmcc
mlmcc