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
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