Print Page | Close Window

ODBC connection to Informix DB Issue Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2022 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15218 Printed Date: 22 Apr 2025 at 12:55am Topic: ODBC connection to Informix DB Issue Posted By: FrnhtGLI Subject: ODBC connection to Informix DB Issue Date Posted: 22 Dec 2011 at 4:58am I am connected to an Informix database and have installed an IBM Informix ODBC driver and the Crystal Reports Informix driver(s). I am able to connect to the database and when I select certain tables I am able to run a report from their fields. I am having an issue with one of the tables though. I can see it, select it and it will populate in the Field Explorer. But when I try to add one of the fields to the report I get the error: Failed to retrieve data from the database. Details: 42000:[Informix][Informix ODBC Driver][Iinformix}A syntax error has occured. [Database Vendor Code: 201] Not sure why this is happening for this table and not all the others. Any clue? ------------- |< /\ '][' ( )

Print Page | Close Window