Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1311
  • Last Modified:

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!
0
AConover
Asked:
AConover
  • 3
  • 2
1 Solution
 
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
 
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
 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now