unable to connect to remote MySQL using ACUSQL
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).
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"
CONNECT TO :servername USER :userid USING :passwd
my compiler options are -Ps -Pr -Pe -o
When i debug this code i get that SQLCODE=-1