Re: ODBC Error

Paul The problem is solved. The protocol settings were wrong in sqlhosts file. Thankx for your help. I got one more application in access and when I try to link the tables I get the following error. [INTERSOLV][ODBC Informix driver][Informix] Attempt to connect to database server [msm_tcp] failed [INTERSOLV][ODBC Informix driver][Informix] Connection refused Thank You Saleem Schaeflein, Paul wrote: > > 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 gprirs> is 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