I just purchased Crystal Reports 2008 and I can't connect to my Informix database on my Unix server. Previous versions of Crystal I have had no issues with (still running 8.5 with no problems).
I do have the latest IBM Informix Client SDK drivers and can successfully connect to the Informix database (as always) with those, BUT only outside of Crystal:
I have gone through the install of Crystal and selected everything. Once complete, I don't have the option of the CR Informix driver in ODBC Admin.
I found this link:
and downloaded these drivers:
After Installing those drivers, I now have the option in ODBC - driver "CR Informix ODBC Driver 5.3". I tried setting up a data source using these, but upon test connect I get this error:
"Crystal ReportsODBC Informix driverInformixA syntax error has occured"
I have tried the "Informix Online Server" option in the database expert utility in Crystal. I can see my database and tables, but upon querying them I get this error:
"Failed to retrieve data from the database"
I know I have all the server and login credentials correct.
Any help would be appreciated!