Re: Using SQL CONNECT problem to MS SQL database

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 08/25/2016
03:15:34 PM:

Exec Sql CONNECT TO AXTRN01
USER :SQL_USER
Using :SqlPwd;
Exec Sql Set Connection AXTRN01;

zSqlCmd = 'Select count(*) into ? from AXTRN01..UNITOFMEASURE'
+ ' where Symbol = '
+ Q + %trim(pUOM) + Q;
Exec Sql Prepare SQLRMTCMD from :zSqlCmd;
Exec Sql Execute SQLRMTCMD using :Count ;

it fails here with the -551.

It looks to me like your MS SQL server instance is either trying
to authenticate using Windows authority (which your JDBC connection won't
have any Windows authority established) or the MS SQL server instance has
not authorized SQL_USER with password SqlPwd to access the database. But,
you said it works from STRSQL? You connected with STRSQL but did you try
the SELECT statement in STRSQL, too?

Sincerely,

Dave Clark