EZSQL003 SQL error code 00000

Document ID : KB000005358
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

EZSQL002 SQL program dqspsxs ended with return code 0016.

EZSQL003 SQL error code 00000,

SQLAllocStmt error, SQLCODE = 0, SQLSTATE = 00000

 

...

Cause:

No SQL CONNECT - because when using CURSOR with an ODBC driver, SQL CONNECT is required.

Resolution:

CONNECT to the data base as shown in the sample. Click this link please: CA Easytrieve SQL CONNECT on Windows example.mht

It contains a CA Easytrieve source example how to use SQL CONNECT with Microsoft SQL Server on Windows 7 with all the data base and ODBC Driver details.

File Attachments:
TEC1905866.zip