We have an application running smoothly with the following configuration: COLDFUSION 4.0 Windows NT 4 et IIS INTERSOLV 3.11 INFORMIX 9 odbc driver INFORMIX IDS 2000 version 9.21 UC3 on a linux Mandrake 7.2 platform
We installed the Coldfusion Enterprise evaluation version, as detailed below: Platform linux RedHat 6.2 Web server apache version 1.3.20 Coldfusion linux 5.0 coldfusion enterprise evaluation INFORMIX IDS 2000 version 9.21 UC3 on a linux Mandrake 7.2 platform in order to implement the application running with NT and COLDFUSION 4.0. Informix SDK client was correctly installed. The ColdFusion Start file does include the following environment variables: INFORMIXDIR, INFORMIXSERVER, ONCONFIG, INFORMIXSQLHOSTS et LD_LIBRARY_PATH The odbc-to-informix connection was correctly installed. The connection functions properly. However, we encounter the problems listed below: 1) ODBC Data Sources a - Many Timeout errors on queries b - S1000-type errors The query detailed below: select an_artic,mois_artic, SUM(qt_vendu_artic) AS qv, round(SUM(ca_ttc_artic),2) AS mt from os_stat_artic,os_artic where n_auto_adhpha_artic in (4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31, 32,33,34) and ( ( mois_artic=03 and an_artic=2002) or ( mois_artic=02 and an_artic=2002) or ( mois_artic=01 and an_artic=2002) or ( mois_artic=12 and an_artic=2001)) and n_auto_artic=n_auto_artic_artic and otc_artic like '1%' group by an_artic,mois_artic order by an_artic,mois_artic generates the following : ODBC Error Code = S1000 (General error) [MERANT][ODBC Informix Dynamic Server driver]10600 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (135:1) to (135:46). Note that the following query does not produce an error: select an_artic,mois_artic, SUM(qt_vendu_artic) AS qv, round(SUM(ca_ttc_artic),2) AS mt from os_stat_artic,os_artic where n_auto_adhpha_artic in (4,5,6,7,8,9,10,11,12,13,14,15,17) and ( ( mois_artic=03 and an_artic=2002) or ( mois_artic=02 and an_artic=2002) or ( mois_artic=01 and an_artic=2002) or ( mois_artic=12 and an_artic=2001)) and n_auto_artic=n_auto_artic_artic and otc_artic like '1%' group by an_artic,mois_artic order by an_artic,mois_artic Can we install another "IDS 2000 (version 9.21 UC3)" compatible driver - such as INTERSOLV 3.11 INFORMIX 9 ? What should be done for this driver to appear in the list of drivers displayed when creating ODBC Data Sources ? 2) Native Data Sources Does the evaluation version allow native access to the database ? Does it work only with INFORMIX73 ? All our attempts failed. We configured the connection as described below: Edit Native Interface Data Source [INFORMIX73] Data Source Name : ospharm Description : <blank> Default Database : ospharm Server : athenes Host : athenes.stpfrance.com Service : 1526 or <blank> same result Protocol : olsoctcp or <blank> same result Client (Local) : <blank> Database (Local) : <blank> Driver : <blank> (Do we have to supply this information? What should we enter?) Translation DLL: <blank> We get the following: Data Source Name Native Driver Status ospharm Informix73 failed Thanks,jm Tiger ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
