×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Connecting to Informix from Crystal Reports

Connecting to Informix from Crystal Reports

Connecting to Informix from Crystal Reports

(OP)
The product we are using is ....... Informix Dynamic Server 2000 - version 9.21.
 
My problem is connecting a Seagate crystal report to the above informix database using the informix ODBC driver. I suspect the error may be with the driver but I'm not sure. Here's a detailed step by step account of whats happening and what the problem is.
 
1. Firstly the report that I am trying to connect to the Informix database was designed in CR 7 (which I don't think is an issue because creating a new report using CR 8 gives the same type of trouble). It also runs perfectly on
the original database it was connected to which is a Sybase SQL database. We have rebuilt this database exactly, using an Informix database instead of the Sybase one and this is where the problem is. The report won't connect to the Informix version. Anyway heres what I've done to try to get it connected up.

    (1) The report opens fine with the saved data from the Sybase database.
    (2) I then go to Database/Verify Database.
    (3) This gives the ODBC driver set up interface.
    (4) Test the connection to the database and that is successful.
    (5) When you press ok to come out of this it gives the error message "Error opening file. There are no fields in the file "DBA.SCHOOL"." It also gives the same message for the other tables in the db.
    (6) Then I go to Database/Set Location.
    (7) I then set the location for the tables involved.
    (8) I set to the folder current connections/(the DSN required).
    (9) It asks if I want to "propagate server and database changes across tables with the same original location". I press ok
    (10) I get "the database file "SCHOOL" has changed, proceed to fix up report ?" I press yes !
    (11) I then repeat the above steps for the sub-report in the report.
    (12) I try to refresh the data
    (13) It then gives the problem........ "ODBC Error: [Informix] [Informix ODBC Driver] General Error. Syntax Error."
    (14) Press ok and you then get ........ "Error detected by database dll"
    (15) If I try to refresh just the sub- report I get the same error.

2. The name of the ODBC Driver I am using is ...... Informix 3.32 32 bit.
The version number is 3.32.00.10616 and the DSN is set up as a System DSN.

3. The following happens if I try to create a report from scratch using the report expert and connecting to the same DSN.
    (1) Pick a standard report
    (2) Choose database button
    (3) Navigate to the ODBC folder and pick the same DSN as earlier.
    (4) It lists all the tables without any problems
    (5) Add a table and click next
    (6) It lists all the fields in that table so I pick 2 and press finish
    (7) It then gives the error ........ " ODBC error: [Informix] [Informix ODBC Driver] [Informix] The specified table "(name of table)" is not in the database.
    (8) and then gives ... "Error detected by database dll."

Anyone got any suggestions what to try next ??

JB


RE: Connecting to Informix from Crystal Reports

Hai JBrowne,
          The error which you have mentioned second i.e "Error detected by database dll" is nothing but if there is any problem with the query it will give you the error. And regarding the ODBC driver my perception is that Informix 3.32 32 BIT driver Supports only windows 2000 as we are also using the same driver. Is your machine windows 2000. These may be the causes for your error. Check from the Control panel whether the Test Connection Succeeds.

Thanks & Regards
Balaji.V

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close