AcuSQL 9.2 is unable to connect to MySQL

0 Likes

Problem:

ACUCOBOL-GT runtime can connect a COBOL application to a MySQL database using the AcuSQL pre-compiler/runtime via ODBC libraries and a local Data Source (DSN).

Starting from release 9.2 the following statement returns the SQL error: SQLCODE=-1

EXEC SQL CONNECT TO :DataSourceName as C1
 USER :UserName USING :Password
END-EXEC.

Resolution:

This is a problem identified within AcuSQL.

Newer versions of the ODBC Driver manager will cause AcuSQL to receive an error when attempting to execute a SQLAllocHandle prior to connecting to an ODBC driver on windows.

This issue is now fixed with ECN-SQL147.

The new ECN will be deployed in upcoming release 9.2.4, available starting next November, 20th, 2014.

SI: 2790903

Claudio Contardi
Product Support Engineer, Senior
Micro Focus

Comment List
Anonymous
Related Discussions
Recommended