Re: Native Informix Drivers with Coldfusion

From: dba_in_orlando@my-deja.com > >I am trying to set up Coldfusion 4.5 (Linux) to >use the native Informix Drivers (IDX 7.30 UC7). >I can get it running with the Merant ODBC, but >get a "Could not do a physical-order read to >fetch next row" error that Informix sez is a >Merant issue and Merant sez is an Informix >issue. Anyone have any suggestions. The >services are: >sqlexec 1525/tcp # Informix >sqlexecf 1526/tcp # Informix > >sqlhosts file >testbar onsoctcp testbox sqlexec >testfoo onsoctcp testbox sqlexecf >testbox onipcshm testbox shm_file> >The LD_LIBRARY_PATH has been added to the CF >server start script. Any insight into which >files to use or what type of configuration to try >would be greatly appreciated. What SQL are you trying to run? _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com

In article <90vvkp$du8$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: dba_in_orlando@my-deja.com > > > >I am trying to set up Coldfusion 4.5 (Linux) to > >use the native Informix Drivers (IDX 7.30 UC7). > >I can get it running with the Merant ODBC, but > >get a "Could not do a physical-order read to > >fetch next row" error that Informix sez is a > >Merant issue and Merant sez is an Informix > >issue. Anyone have any suggestions. The > >services are: > >sqlexec 1525/tcp # Informix > >sqlexecf 1526/tcp # Informix > > > >sqlhosts file > >testbar onsoctcp testbox sqlexec > >testfoo onsoctcp testbox sqlexecf > >testbox onipcshm testbox shm_file> > > >The LD_LIBRARY_PATH has been added to the CF > >server start script. Any insight into which > >files to use or what type of configuration to try > >would be greatly appreciated. > > What SQL are you trying to run? The current system gets a fetchrow error on select statement (CFSERVER 4.5 running on NT) with two tables, two where clauses, and an order by. The plan is if we can get the native drivers set up, then we run Linux instead of NT. On the Linux box, I can get CF to see the IDS instance using the ODBC, but we would like to use the native drivers if possible. Thanks for you help. Sent via Deja.com http://www.deja.com/ Before you buy.