AConover
asked on
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!
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!
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
Not the answer I was hoping for, but nonetheless it's accurate. Thanks.
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