IDS 7.3 connectivity for ColdFusion

IDS 7.3 connectivity for ColdFusion

Post by guankia » Sun, 31 Dec 1899 09:00:00



Hi

I've install Client SDK 2.40 on a Linux machine. The machine is also running
ColdFusion App server. I've created a DSN to connect to IDS 7.3 on another
machine. But I keep hitting problem when I verify the connectivity in
ColdFusion.
Can anyone please help. Thank you

In /etc/services files
testdb     2829/tcp                        # Informix Test Database

In /opt/informix/sqlhosts files
testdb    seipcpip        pisces          testdb

The following was placed in the odbc.ini file under ColdFusion directory

[testdb]
Driver=/opt/informix/lib/cli/iclis09b.so
Description=INFORMIX 3.3 32-BIT
Database=testdb
LogonID=ID
pwd=password
Servername=testdb
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so

Best Regards
guankiat

 
 
 

IDS 7.3 connectivity for ColdFusion

Post by Obnoxio The Clow » Sun, 31 Dec 1899 09:00:00



Quote:

>I've install Client SDK 2.40 on a Linux machine. The machine is also
>running
>ColdFusion App server. I've created a DSN to connect to IDS 7.3 on another
>machine. But I keep hitting problem when I verify the connectivity in
>ColdFusion.
>Can anyone please help. Thank you

>In /etc/services files
>testdb     2829/tcp                        # Informix Test Database

>In /opt/informix/sqlhosts files
>testdb    seipcpip        pisces          testdb

Have you tried:

testdb    setlitcp        pisces          testdb

or

testdb    sesoctcp        pisces          testdb

Also, have you started the sqlexecd daemon?

Quote:>The following was placed in the odbc.ini file under ColdFusion directory

>[testdb]
>Driver=/opt/informix/lib/cli/iclis09b.so
>Description=INFORMIX 3.3 32-BIT
>Database=testdb
>LogonID=ID
>pwd=password
>Servername=testdb
>CursorBehavior=0
>CLIENT_LOCALE=en_us.8859-1
>DB_LOCALE=en_us.8859-1
>TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so

>Best Regards
>guankiat

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com