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 *
|
