Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
m1chael Absent Member.
Absent Member.
880 views

unable to connect to remote MySQL using ACUSQL

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

1 Reply
Ektoras Giorgos
New Member.

RE: unable to connect to remote MySQL using ACUSQL

I have the exactly same issue! anyone can help?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.