Crystal Reports 2008 and Informix (on Unix)

Posted on 2009-02-12
Last Modified: 2013-12-24

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!
Question by:AConover
    LVL 100

    Expert Comment

    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

    What version of Informix do you have?

    LVL 1

    Author Comment

    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.
    LVL 100

    Accepted Solution

    As stated those drivers arre for much later versions of Informix.  It may be there is no way to use Informix 5 with CR2008

    LVL 1

    Author Comment

    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.

    LVL 1

    Author Closing Comment

    Not the answer I was hoping for, but nonetheless it's accurate.  Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now