problems to connect to indormixserver via odbc

hi,... i got big problems to connect to informix dynamic server 7.3(linux edition) via odbc when i connect to the database with php3 on same machine, there is no problem.... i want to connect from Win-clients (98/nt) to my informix database(installed on suse linux) when i try to connect, in onstat -u there is my name listed, but the program on windows hangs (can not move or close...) the flags are set to Y--P--- (Y -- Waiting on a condition, P -- prepared for commit) environment-variables: INFORMIXDIR=/opt/informix INFORMIXSERVER=linux_ipc ONCONFIG=onconfig LD_LIBRARY_PATH=/opt(informix/lib:/opt/informix/lib/esql etc/onconfig: DBSERVERNAME linux_ipc DBSERVERALIASES linux_soc NETTYPE ipcshm,1,100,NET NETTYPE onsoctcp,1,100,CPU etc/sqlhosts: linux_ipc onipcshm linux linux_ipc linux_soc onsoctcp linux sqlexec /etc/services: sqlexec 1526/tcp /etc/hosts: 127.0.0.1 localhost 192.168.164.54 linux.master linux in one of all the HowTo's, there was a chapter which descibes, how to allow romote connections,... they write something bout $INFORMIXDIR/lib/sqlexec and $INFORMIXDIR/lib/sqlexecd... but i do not have them...... perhaps this is my problem....where can i get these files(and some more)... i searched at informix and intraware, but i found nothing... thanks -- Wolfgang :artintec http://www.artintec.de/ http://www.vb-welt.de/

Wolfgang Kluge <kluge@artintec.de> schrieb in im Newsbeitrag: 80rtqv$2k6t$1@news.lf.net... > hi,... > i got big problems to connect to informix dynamic server 7.3(linux edition) > via odbc Have a look at the entries in /etc/services and C:\\winnt\\system32\\drivers and sqlhosts > /etc/services: > sqlexec 1526/tcp > linux_soc onsoctcp linux sqlexec> I would not name the service for linux_soc sqlexec. May be it is reserved. Give him a name like linux_tcp and add a unique port number in /etc/services and the services File on NT: linux_tcp 6001/tcp # online Netzwerk BTW: With onstat -g ses sessionid you will see more about the tread possible the sql error HTH Reinhard

Wolfgang Kluge <kluge@artintec.de> wrote in message 80rtqv$2k6t$1@news.lf.net... > hi,... > i got big problems to connect to informix dynamic server 7.3(linux edition) > via odbc > > when i connect to the database with php3 on same machine, there is no > problem.... > > i want to connect from Win-clients (98/nt) to my informix database(installed > on suse linux) U must configure client machine > when i try to connect, in onstat -u there is my name listed, but the program > on windows hangs > (can not move or close...) > the flags are set to Y--P--- (Y -- Waiting on a condition, P -- prepared for > commit) > > environment-variables: > INFORMIXDIR=/opt/informix > INFORMIXSERVER=linux_ipc > ONCONFIG=onconfig > LD_LIBRARY_PATH=/opt(informix/lib:/opt/informix/lib/esql> Locale machine on win98 need know informixdir like c:\\progdir\\informix informixserver=linux_ipc hostname = linux.master NOTE : informixserver usually is <> from hostname u must know informixserver when choose db from dbaccess u can see informixserver@your_dbname > etc/onconfig: > DBSERVERNAME linux_ipc > DBSERVERALIASES linux_soc > NETTYPE ipcshm,1,100,NET > NETTYPE onsoctcp,1,100,CPU> > etc/sqlhosts: > linux_ipc onipcshm linux linux_ipc > linux_soc onsoctcp linux sqlexec> > /etc/services: > sqlexec 1526/tcp the services file on your client must have the same service > /etc/hosts: > 127.0.0.1 localhost > 192.168.164.54 linux.master linux Bye Max