If you get connection refused, something is not listening on that port,
period, end of story. I do not have the setup to test this but I'm thinking
you may want to check that the port is opened and waiting for connection.
There is a command to check the status of the ports and I am having a very
senior moment (ok, hour). Something like NETSTAT or some utility in
NET.SYS.
Is there also a way to configure the port for the ODBC connection server?
Denys
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
Of John Pitman
Sent: Wednesday, September 21, 2011 6:01 PM
To: [log in to unmask]
Subject: Re: [HP3000-L] FW: ODBC CONNECTION TO IMAGSQL - CONNECTION REFUSED.
Now have the job running OK, but getting same msg.....same codes.
questions :-
does sql base need to be fully qualified in the odbc definition?
Log file shows a bad date ...
:print odbclog.odbcse
111/09/22 08:15:32 0303 ODBC Listener Started
stdlist:-
:JOB ODBCLNSE,MANAGER.SYS,ODBCSE.
Priority = CS; Inpri = 8; Time = UNLIMITED seconds.
Job number = #j1852.
THU, SEP 22, 2011, 8:15 AM.
HP3000 Release: C.75.00 User Version: C.75.00
MPE/iX HP31900 C.45.05 Copyright Hewlett-Packard 1987.
All rights reserved.
STREAMED BY MANAGER.SYS (#S4119) ON LDEV# 12
STREAM DATE: THU, SEP 22, 2011, 8:15 AM
:comment ODBCLink (Special Edition) listener process
:setdump
:CONTINUE
:purge odbclog
:comment setvar odbc_debug 5
:odbclnse.odbcse.sys server
dbmon.pub.sys (created SAT, SEP 6, 2003):
@(#)HPDBCORE A.G3.32 12/03/01 ALLBASE/SQL
(24/23) Continue?
________________________________________
From: HP-3000 Systems Discussion [[log in to unmask]] On Behalf Of Mark
Undrill [[log in to unmask]]
Sent: Wednesday, 21 September 2011 8:39 PM
To: [log in to unmask]
Subject: Re: [HP3000-L] FW: ODBC CONNECTION TO IMAGSQL - CONNECTION REFUSED.
John Pitman wrote:
> P Please consider the environment before printing this e-mail.
> From: John Pitman [mailto:[log in to unmask]]
> Sent: Wednesday, 21 September 2011 1:36 PM
> To: [log in to unmask]
> Subject: ODBC CONNECTION TO IMAGSQL - CONNECTION REFUSED.
>
> I HAVE an image base with an sql base defined over it. I can
connect
> ISQl to it fine.
> I have installed the odbcse stuff in windows, and
ODBCLink/SE-32
> Driver shows up in data sources.
> I have defined a data source in the ODBC admin screens.
> The listener service is running (JSTRTMON.JDBC.SYS) When I try to
> connect Winsql , I get as below....the above jobs
shows
> no messages
>
> Sql error state : s1000 native error code: FFFFFFFF, odbc error
> [WSOCK32.dll] connection refused, is host listener running?
(#10061)
>
> Base is defined as RSTOCK.ASP.STOCK2K, at system IP, type
MPE/ix
> With user name as in 'add user' below
>
>
> User is ok, password is as shown by mpe listuser, and is added
after
> the Attach, which runs without error:- ADD USEr SYDMB@STOCK2K WITH
> CLASS=15,MODE=1
>
> Any suggestions please?
> Regards,
>
> John Pitman
>
I think the "listener" job for ODBC is ODBCJOB.ODBCSE.SYS.
STRTMON.JDBC.SYS is for JDBC.
Regards
--
Mark Undrill
Affirm Limited
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
CAUTION: This message may contain privileged and confidential information
intended only for the use of the addressee named above. If you are not the
intended recipient of this message you are hereby notified that any use,
dissemination, distribution or reproduction of this message is prohibited.
If you have received this message in error please notify RYCO Hydraulics
Pty. Ltd. immediately. Any views expressed in this message are those of the
individual sender and may not necessarily reflect the views of RYCO
Hydraulics Pty. Ltd.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
