Uh, Duh...... :-(
Why didnt I think of that....I sort of assumed that if java progs could talk to Imagesql, it was the same thing....
Will check asap and advise..
jp
________________________________________
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 *
|
