Problem establishing an ODBC connection cont.

... i tried the ilogin utility with following result: Error -908 Attempt to connect to database server (servername) failed. The program or application is trying to access another database server but has failed. Note the server name in the current statement. **************************************************************** original message: 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

Hi! Have you tried without full system name: just gambit on both client and server?? How about fixing gambit in hosts file on the client? Everything you setup looks good, I am trying to identify what I setup differently on my machine. HTH Michael oliver fodor wrote: > ... i tried the ilogin utility with following result: > > Error -908 > > Attempt to connect to database server (servername) failed. > > The program or application is trying to access another database server but > has failed. Note the server name in the current statement. > > **************************************************************** > original message: > > 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