Crystal Reports 2008 and Informix (on Unix)

Hello,

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:
http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2007-11-01+10%3A22%3A53.782388R&S_TACT=104CBW71&S_CMP=

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:
https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11484
and downloaded these drivers:
https://smpdl.sap-ag.de/~sapidp/012002523100008666562008E/cr_datadirect53_win32.zip

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!
LVL 1
AConoverAsked:
Who is Participating?
 
mlmccCommented:
As stated those drivers arre for much later versions of Informix.  It may be there is no way to use Informix 5 with CR2008

mlmcc
0
 
mlmccCommented:
Is this from the designer when you try to create a report?

It seems from a quick search that you have the correct drivers
This article says they are for Informix 9.4 and 10.0
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f05523e4-35c4-2b10-2c89-9fcf64b0dd22

What version of Informix do you have?

mlmcc
0
 
AConoverAuthor Commented:
Thanks for replying.

If I install the Informix drivers for Crystal, create and ODBC datasource, I get the error.  I also get the error creating a new database connect from within Crystal.

I'm using Informix 5.
0
 
AConoverAuthor Commented:
That got me thinking.  I had some older datadirect drivers (v4.2).  I installed them and they seem to be working with Crystal 2008 and Informix 5.

0
 
AConoverAuthor Commented:
Not the answer I was hoping for, but nonetheless it's accurate.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.