RE: ODBC Error
The -951 error is probably yours. What is the connect string?
Please respond to the list/newsgroup so others will learn.
-----Original Message-----
From: Saleem Mohammad [mailto:smohamm1@ford.com]
Sent: Monday, June 21, 1999 4:56 PM
To: Schaeflein, Paul
Subject: Re: ODBC Error
Hi Paul
This is what I have when I do onstat -m
VBTEST :/usr/informix>onstat
-m
INFORMIX-OnLine Version 7.22.UC1 -- On-Line -- Up 06:31:16 -- 318024
Kbytes
Message Log File:
/u/db/log/db1.log
15:20:12 listener-thread: err = -951: Incorrect password or user gprirsis not
known on the database
server.
15:24:14 Checkpoint Completed: duration was 0
seconds.
15:33:12 Checkpoint Completed: duration was 21
seconds.
15:38:14 Checkpoint Completed: duration was 0
seconds.
15:43:18 Checkpoint Completed: duration was 0
seconds.
15:48:18 Checkpoint Completed: duration was 0
seconds.
15:53:19 Checkpoint Completed: duration was 0
seconds.
16:03:19 Checkpoint Completed: duration was 0
seconds.
16:08:19 Checkpoint Completed: duration was 0
seconds.
16:15:00 Logical Log 2935
Complete.
16:15:01 Process exited with return code 127: /bin/sh /bin/sh -c
/usr/informix/log_full.sh 2 23 "Logical Log 2935 Complete." "Logical Log 2935
Complete."
16:18:20 Checkpoint Completed: duration was 1
seconds.
16:33:23 Checkpoint Completed: duration was 0
seconds.
16:48:26 Checkpoint Completed: duration was 0
seconds.
17:03:30 Checkpoint Completed: duration was 0
seconds.
17:15:12 Logical Log 2936
Complete.
17:15:13 Process exited with return code 127: /bin/sh /bin/sh -c
/usr/informix/log_full.sh 2 23 "Logical Log 2936 Complete." "Logical Log 2936
Complete."
17:18:34 Checkpoint Completed: duration was 1
seconds.
17:33:34 Checkpoint Completed: duration was 0 seconds
Thank You
Saleem
Schaeflein, Paul wrote:
>
> What does the Informix log file show (onstat -m)?
>
> -----Original Message-----
> From: Saleem Mohammad [mailto:smohamm1@vbws01.ba.ford.com]
> Sent: Monday, June 21, 1999 9:49 AM
> To: informix-list@iiug.org
> Subject: ODBC Error
>
> Hi Everyone,
> I am running informix 7.22 UC1 on AIX 4.1.5. I am trying to acces
> the database from an access/VC++ applications and I end up with the
> following error.
>
> Run-time Error '40002';
> S1000: [INTERSOLV][ODBC Informix Driver][Informix] Connection
> refused.
>
> I did the following in setting up the connection.
>
> 1. Installed informix client on the PC.
> 2. Set up my sqlhosts and /etc/services files.
> SQL HOSTS:
> some_name onscotcp my_host_name sqlexec_prod
>
> /etc/services"
> sqlexec_prod 2026/tcp
>
> 3. Set up my ODBE connection wiht the above data.
>
> Please advise.
>
> Thank You
> Saleem