Joined: 22 May 2009
Online Status: Offline
Posts: 347
Topic: ODBC connection to Informix DB Issue 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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged