Re: Problem establishing an ODBC connection
Posted in 1999
hi mohammad!
thanks for your help. you was right, the process wasn't started. since i
don't have any administartor manual, i don't know if there are some
attributes necessary. i started sqlexec with following command line:
./sqlexec gambit_se &
the PID:
21772 p2 T 0:00 \\_ ./sqlexec gambit_se LESSOPEN=|lesspipe.sh
%s ign
i'm not quite sure if this is right. however the result is the same as it
was before.
how does the command line have to look like. sorry for bothering you with
this trivial questions but the internet connectivity here in colombia is
very slow and i can't find any informations.
thanks, oliver
At 16:04 08.10.99 -0400, you wrote:
>Hi,
> You should have sqlexec running for that instance. Check if sqlexec is
>running in the ps -fea | grep sqlexec. If you don't find a PID for that,
>login as root and start the sqlexec process.
>
>Thank You
>Mohammad Saleem
>
>oliver fodor 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