SQLSTATE=42704 when running a query in OpenESQL Assistant against DB2 ODBC DSN in Visual COBOL for Visual Studio

0 Likes
over 7 years ago

Problem

SQLSTATE=42704 error seen when running a query in OpenESQL Assistant against DB2 ODBC DSN in Visual COBOL for Visual Studio

Resolution

When the DB2 ODBC connection is setup, you must not define a default user and password.

If you take those defaults out the connection will be made successfuly.

This issue is related to how the preprocessor checks for the objects, and changing the above resolves this.

Comment List
Anonymous
Related Discussions
Recommended