Timeout expired error occurring during SQL SELECT with RPG2SQL

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

-2147467259 [Microsoft][ODBC SQL Server Driver]Timeout expired error was occurring when doing 2 SQL select statements from an SQL Server database. User would run first SQL record select and loop through the database without error, but the second SQL SELECT statement would cause the program to lock up and the timeout error to occur when a MoveFirst was done right after the SQL SELECT.

Solution:

We removed the setting of the ActiveConnection property of ADO command object from the DBConnect method. This appeared to be causing the SQL timeout if 2 SQL statements were run one after the other. We now always set the ActiveConnection property before using the ADODB.Command object and we reset this property when done with the ADODB.Command object. This appears to be some sort of bug in the Microsoft ADO database drivers for SQL Server.

Have user update to Version 1.0.38 or above of the RPG2SQL Integrator PC component.