IDS 7.31 connect Cold Fusion Server 4.5
Poster asked whether anyone had connected Allaire ColdFusion Server 4.5 to IDS 7.31 using the Informix CLI/native drivers. One respondent reported success with CF 4.01 against IDS 7.24/7.30, but only via the ODBC driver, and noted that $INFORMIXDIR/lib and $INFORMIXDIR/lib/esql must be in LD_LIBRARY_PATH. The original poster later reported it working (Solaris 7, IDS 7.3 Workgroup) with help from Allaire, posting a full working config: the CF native Informix73 data source settings, sqlhosts entry, INFORMIXDIR/INFORMIXSERVER/INFORMIXSQLHOSTS exports in the coldfusion start script, LD_LIBRARY_PATH including lib, lib/cli (libthcli.so) and lib/esql, plus a sample CFQUERY. A side question about Standard Engine got no definite answer.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Has anyone been successful connecting to IDS 7.31 via CLI drivers from Allaire's Cold Fusion Web Application Server 4.5? Kim
In article <874p9u$fr0$1@nntp4.atl.mindspring.net>, "KCStout" <kstout@masconsulting.com> wrote: >Has anyone been successful connecting to IDS 7.31 via CLI drivers from >Allaire's Cold Fusion Web Application Server 4.5? >Kim > > > > I don't know about CF Version 4.5 but we're using CF 4.01 with IDS 7.24 and 7.30 Lyzander * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!
Lyzander, Did you setup the Informix Client SDK on the same UNIX box where your IDS resides? Does the Cold Fusion Server verify your native driver data source OR did you setup an ODBC data source and verify? I have sqlhosts setup correctly and I changed the Cold Fusion start script to point to the directory where the client sdk was installed. Kim Zandy wrote in message <2b8829d2.26876736@usw-ex0105-038.remarq.com>... >In article <874p9u$fr0$1@nntp4.atl.mindspring.net>, "KCStout" ><kstout@masconsulting.com> wrote: >>Has anyone been successful connecting to IDS 7.31 via CLI >drivers from >>Allaire's Cold Fusion Web Application Server 4.5? >>Kim > >I don't know about CF Version 4.5 but we're using CF 4.01 with >IDS 7.24 and 7.30 > >Lyzander > >* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * >The fastest and easiest way to search and participate in Usenet - Free!
Kim,
In article <874vkp$28c$1@nntp1.atl.mindspring.net>, "KCStout"
<kstout@masconsulting.com> wrote:
>Lyzander,
>Did you setup the Informix Client SDK on the same UNIX box
>where your IDS resides?
Yes. But it should also work with just the Client SDK installed.
>Does the Cold Fusion Server verify your native driver data
>source OR did you setup an ODBC data source and verify? I have
>sqlhosts setup correctly and I changed the Cold Fusion start
>script to point to the directory where the client sdk was
>installed.
>Kim
I wasn't able to get the Native Driver working but the ODBC
Driver works though. Try installing the Server in the machine
just so you can use dbaccess to debug the server connection.
Lyzander
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Oh! I forgot to add that you must include $INFORMIXDIR/lib:$INFORMIXDIR/lib/esql in your LD_LIBRARY_PATH. HTH Lyzander * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!
Lyzander, Just to confirm. Are you using Online Dynamic Server and cold fusion ? I have a Standard Engine that I would like to access it from the web. Any suggestions ? Thanks Ram S. In article <1506d160.cd18e4b7@usw-ex0105-036.remarq.com>, Zandy <zandymNOzaSPAM@yahoo.com.invalid> wrote: > Oh! I forgot to add that you must include > $INFORMIXDIR/lib:$INFORMIXDIR/lib/esql in your LD_LIBRARY_PATH. > > HTH > > Lyzander > > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * > The fastest and easiest way to search and participate in Usenet - Free! > > Sent via Deja.com http://www.deja.com/ Before you buy.
Sun Solaris 7 (v2.7) Informix Dynamic Server 7.3 Workgroup Edition
Allaire helped, the thread on their beta site is -
http://beta.allaire.com/general/index.cfm?CFID=260915&CFTOKEN=99657
// ColdFusion Server Administrator Native Drivers data sources
Edit Native Interface Data Source [INFORMIX73]
DataSource Name: inf_native
Default Database: testdb
Server: chapel_net
Host: chapel
Service: idswe1
Protocol: ontlitcp
Client Locale: en_US.CP1252
Database Locale: en_US.CP1252
ColdFusion Login username: informix Password: ******
// Entries in /opt/coldfusion/start
CFHOME=/opt/coldfusion;export CFHOME
// Location of Informix Client s/w
INFORMIXDIR=/opt/isdk;export INFORMIXDIR
INFORMIXSERVER=chapel_net;export INFORMIXSERVER
INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts;export INFORMIXSQLHOSTS
LD_LIBRARY_PATH=/usr/dt/lib:/lib:/usr/openwin/lib:$CFHOME/libexport LD_LIBRARY_PATH
// libthcli.so resides in $INFORMIXDIR/lib/cli
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFORMIXDIR/lib:$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql
export LD_LIBRARY_PATH
// END Entries in /opt/coldfusion/start
// $INFORMIXDIR/etc/sqlhosts
chapel_net ontlitcp chapel idswe1
// CFQUERY for native driver
<cfquery name="acct" dbserver="chapel_net" dbtype="Informix73"
datasource="inf_native" maxrows=10> SELECT * FROM account
</cfquery>
KCStout wrote in message <874p9u$fr0$1@nntp4.atl.mindspring.net>...
>Has anyone been successful connecting to IDS 7.31 via CLI drivers from
>Allaire's Cold Fusion Web Application Server 4.5?
>Kim
>
>
Yes, I'm using IDS. I haven't used SE but try asking Informix whether their ODBC driver works with SE (I think it should). If not, try asking other ODBC vendors. Lyzander In article <87cbrf$i4l$1@nnrp1.deja.com>, ram_cnc <rsivaguru@my-deja.com> wrote: >Lyzander, > >Just to confirm. Are you using Online Dynamic Server and cold fusion ? >I have a Standard Engine that I would like to access it from the web. > >Any suggestions ? > >Thanks > >Ram S. > > >In article <1506d160.cd18e4b7@usw-ex0105-036.remarq.com>, > Zandy <zandymNOzaSPAM@yahoo.com.invalid> wrote: >> Oh! I forgot to add that you must include >> $INFORMIXDIR/lib:$INFORMIXDIR/lib/esql in your LD_LIBRARY_PATH. >> >> HTH >> >> Lyzander >> >> * Sent from RemarQ http://www.remarq.com The Internet's Discussion >Network * >> The fastest and easiest way to search and participate in Usenet - >Free! >> >> > > >Sent via Deja.com http://www.deja.com/ >Before you buy. > > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!