We had a very similar problem except on Crystal 9. Loaded all the patches (2?) from Crystal's web site and now "appears" to be working. We are now in process of testing on X and XI.
Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: Monday, June 06, 2005 11:11 AM To: [email protected] Subject: [U2] Crystal Reports XI ODBC connection to Universe 10.1.7 POSTED ON BEHALF OF NON-MEMBER ([EMAIL PROTECTED]) Hi all, New to the list; I've browsed the archives but cannot find anything relating to specifically the problem I am having, so if anyone can offer assistance it would be much appreciated. Crystal Reports XI trying to access Universe 10.1.7 using the ODBC drivers IBM UniVerse ODBC driver version 4.00.01.7084 The report reads the dictionary - that is, it produces a list of field names and data types. It will not "browse data" when a field is selected: it returns an empty dialogue box. Previewing the report generates an error as follows: Failed to retrieve data from the database. Details: HY000:[IBM][UVODBC][1401032]Error ID: 46 Severity:ERROR Facility: DBCAPERR - UCI Error. Func: SQLPrepare(DML); State: S1000; uniVerse code: 950088; Msg: [IBM][SQL Client][UNIVERSE]Universe/SQL:syntax error. Unexpected filename. Token was "VENDOR". Scanned command was FROM "VENDOR" "VENDOR". [Database Vendor Code: 950088]. Where VENDOR is the name of the file being accessed. Does anyone have this particular configuration working? Can anyone suggest why it might not be working? Thanks in advance for all assistance. Rich ------------------------------------- Richard Minshaw Senior Systems Analyst Alan Nuttall Ltd 01455 638300 ext 410 ------------------------------------- -- This email and its contents have been scanned for viruses by Alan Nuttall Ltd. The views and opinions expressed in this email are those of the composer, which may or may not be those of Alan Nuttall Ltd. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
