Hello everyone,

I have a problem understanding how acubench and acusql are trying to connect to mysql!!

I include this to my work storage

EXEC SQL INCLUDE SQLCA END-EXEC.

EXEC SQL BEGIN DECLARE SECTION END-EXEC.

01 servername pic x(30).
01 userid pic x(30).
01 passwd.
49 passwd-length PIC s9(4) comp-5 value 0.
49 passwd-name PIC x(18).

EXEC SQL END DECLARE SECTION END-EXEC.

I also do this to get the length for the passwd

INSPECT passwd-name TALLYING passwd-length FOR CHARACTERS
BEFORE INITIAL " ".

and this is my esql command where servername is "something.com:3306" userid is "admin" and passwd-name is "password"

EXEC SQL
CONNECT TO :servername  USER :userid USING :passwd
END-EXEC.

my compiler options are -Ps -Pr -Pe -o

When i debug this code i get that SQLCODE=-1