Re: SQLSTATE 08S03, SQLCODE -30060.

Hi Alan

For sure you can see what the SQLCODE is about - when you have one of these -30000 things, make a message ID with 'SQ' followed by the number without the sign.

Here it would be SQ30060. Use this command:

     dspmsgd sq30060 qsqlmsg

As for the SQLSTATE value, go to Knowledge Center, any release, basically, go to Database, then to SQL manuals, I think - in there look for SQL Messages and Codes

If this is an SQLSTATE from IBM, it may or may not be there - this one is not. It's possible that this comes from ArdGate itself, not sure.

But the 1st 2 characters have a meaning - so if you search for "08", you'll find a section: Class Code 08: Connection Exception

HTH
Vern

On 11/14/2017 3:10 PM, Alan Shore wrote:

Hi everyone
Before I forget - I am on V7r1

I am attempting to use ARDGATE

http://www.rpgiv.info/mambo/index.php?option=com_content&task=view&id=473&Itemid=9

and I have it working on our development box
I have just promoted everything to our production box - and when I attempt to connect to an external database, I receive

SQLSTATE 08S03, SQLCODE -30060.

When I F1 over this message - it doesn't really say anything

I have googled SQLSTATE 08S03 but NOTHING is displayed
Does anyone know where this is defined?


Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill