Re: SQLCODE -113, SQLSTATE 28000 on CONNECT TO

I would try adding Varying to the definition
++
Dennis
++
"You can make more friends in two months by becoming interested in other people than you can in two years by trying to get other people interested in you."
-- Dale Carnegie




Sent from my Galaxy tablet phone. Please excuse my brevity.
For any grammatic/spelling errors, there is no excuse.
++


"Gary Thompson" <GThompson@xxxxxxxxxxx> wrote:

I am attempting to connect to Microsoft Sql Server from an SQLRPGLE
program.

ArtGate is installed and I get good results from STRSQL.

(many thanks to Dieter Bender)

The relevant D specs are:
D wkUser S 8A Inz('uuuuuuuu')
D wkUsing S 30A Inz('xxxxxx')

The relevant code is:
EXEC SQL connect to JDBCTEST user :wkUser using :wkUsing;

SQL Messages and Codes indicates: "Authorization name is invalid.",
which
I
think means the value for host variable wkUser is not valid, but I have

checked
and re-checked this for spelling and case.

I am also sure the value of the host variable for the password has the
correct
spelling and case and is left-justified.

My latest attempt was to change the host variable length to match the
number
of characters in the MS Sql Server user account.

Maybe I need to create an authorization list?

Maybe I have a data type problem?
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.