Re: Problem establishing an ODBC connection

It seems to me that in the sqlhosts the right protocol description should be sesoctcp Is it the problem (if it is don't forget to change the protocol on the NT side too)? Best Regards, Octav schatzy@my-deja.com wrote: > > Oliver, > > Can you connect successfully on the Linux server with the "dbaccess" > command. You'd have to make sure INFORMIXDIR and INFORMIXSERVER were > set properly before doing this. > > If you're able to get in this way, please ensure you have all the > appropriate environment variables set in the Openlink oplrqb.ini > [generic_inf72] section. (Assuming you're using the "Informix 7.2" > server type). Depending on your version of Openlink, you may have to > set one or more of the following variables: > > DBPATH=<full path to .dbs database>> DELIMIDENT=Y > INFORMIXDIR=<Informix installation directory> (required) > INFORMIXSERVER=<Informix server in sqlhosts> (required)> OPL_INF_MULTISESS=Y > SQLEXEC=sqlexecd > > Best Regards, > > Stephen Schadt > Openlink Product Support > http://www.openlinksw.com > news://news.openlinksw.com > > In article <7tl3if$gp2$1@news.xmission.com>, > oliver fodor <ofodor@nevado.cui.edu.co> wrote: > > > > I can't establish an ODBC connection to my Informix SE database (Linux > > server) using Informix 3.30 32 Bit ODBC Driver for Win NT (Client). > When > > "Testing Connection" in the driver manager, following error message > appears: > > > > SQL error: [Informix][Informix ODBC Driver][Informix]Attempt to> connect to > > database server (gambit_se) failed., > > SQL state 08004 in SQLConnect > > > > Please if you can help me with this problem. I have been figting it > for a > > long time but can't find any solution. > > > > My setup is: > > > > Server: > > > > - INFORMIXDIR/etc/sqlhosts: > > gambit_se onsoctcp gambit.cui.edu.co sqlexec> > > > - sqlexecd started: > > > > 1999-10-08 09:09:26.580176 Starting Daemon INFORMIX-SQL Version > 7.24.UC5 > > Command Line = ./sqlexecd gambit_se -l ifx.log > > INFORMIXDIR = /usr/informixse > > dbservername = gambit_se > > nettype = onsoctcp > > hostname = gambit.cui.edu.co > > servicename = sqlexec > > options = > > > > - /etc/services: > > > > sqlexec 1536/tcp # SUP debugging > > > > Client: > > > > 1. I set up all the necessary in Setnet32 (INFORMIXDIR, > INFORMIXSERVER, > > Server Info, Host Info) > > > > 2. The winnt\\system32\\drivers\\etc\\services file includes following > entry: > > sqlexec 1536/tcp > > > > 3. i created an System DSN with all relevant data > > > > ... connection doesn`t work :( neither with OpenLink ODBC Driver > > > > thanks, oliver > > > > Sent via Deja.com http://www.deja.com/ > Before you buy. -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com