Oninit cdi / Archive
Talk to an expert →

Re: Native Informix Drivers with Coldfusion

Posted in 2000

Topics: SQL Development & Query Writing, Connectivity: ODBC / JDBC / .NET, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

In the year of Our Lord Mon, 11 Dec 2000 14:11:39 GMT, dba_in_orlando@my-deja.com broke a vow of silence to utter: >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. Can you run the SQL via dbaccess?

↪ replying to Obnoxio The Clown
dba_in_orlando@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

In article <3a34e691.14240677@News.CIS.DFN.DE>, obnoxio@hotmail.com (Obnoxio The Clown) wrote: > In the year of Our Lord Mon, 11 Dec 2000 14:11:39 GMT, > dba_in_orlando@my-deja.com broke a vow of silence to utter: > > >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. > > Can you run the SQL via dbaccess? Yes I can, and I dont get the fetch row errors Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary