Crystal report XI, IBM Universe

[salmanag81]

Hi,

I am trying to retreive data from crystal report XI developer edition from IBM Universe. I can connect to my database through ODBC, I can access tables and see fields in them. Once I try to get data (through preview) it comes up with following error.


"Failed to retrieve data from the database".

Details : HY000:[IBM][UODBC][1401030] ERROR ID:46 Severity:Error Facility DBCAPERR - UCI Error. Func:SQL Prepare(DML);State S1000; uniVerse Code: 950088; Msg;[IBM][SQL Client][UNIVERSE]Universe/SQL:syntax error.Unexpected filename. Token was "CALLS". Scanned command was From "CALLS" "CALLS". [Database Vendor Code: 950088].


Note: I can access the data from Excel spreadsheet easily.


I hope somebody will be able to help me.

Thanks

Salman

 

[synapsevampire]

I'd make sure that you have the latest service pack as they address many connectivity concerns in CR XI and IBM Universes:

http://support.businessobjects.com/downloads/updates/service_packs/default.asp

-k

 

[salmanag81]

Hi,

I tried it but it didn't work out unfortunately.

 

[Turkbear]

Hi,
Have you looked at the Sql code that is being sent to the database ( using the Database..Show Sql option)?

You should see where "CALLS" "CALLS" is in the query and that looks like what the error is referencing..



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[salmanag81]

This query is generated by Crystal reports itself. I simply dragged one field from table to test wheter it works or not.

 

[Turkbear]

Hi,
OK, Try the 'Verify Database' option and see what message is returned..

Does the Universe help file have any more info on that error number (95008) and possible corrections?




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[salmanag81]

Thanks for your reply,

If I do verify database, it says, database is upto date.

I have contacted our supplier for Error Code guide.

Thanks again.