Re: SQLSTATE 08S03, SQLCODE -30060.

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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