Problem:

Customer was running an ADO connection to a Microsoft SQL Server with RPG2SQL. Their program would halt at the SQL_Connect statement with a valid Rtn value and a RtnErr = LastFullErr value of *ERROR*. On the PC component, the log screen shows an Error 52: File Not Found message and nothing else. Syntax for the connection was verified to be valid.

Solution:

Checked the PC component settings and logging was enabled. Verified the location of the logfile was valid; however, the logfile was well over 4.2GB in size which is about the limit for standard text files. We cleared this logfile and disabled logging on the PC component to make the RPG2SQL functional again.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016