SQL Database Error after version change

[Jeffrey Ferreira]

Hello,

We have a client that is migrating from pxplus 16.20 to 19.10.
We have a Pxplus write record of a native sql command that reads from an Infor SQL Database.
In 16.20 it works but in 19.10 i get this error

HY000: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt

the command is just a "SELECT *" statement.

does anyone have any thoughts/insights.

jeff

[Devon Austen]

Hi Jeff,

That error is coming from the Microsoft SQL Server ODBC driver.

So the error appears to be happening on their end.

Is this using a different version of the MS SQL Server ODBC as when you were using PxPlus 16.20?

Is this a different DSN for the ODBC connection then when used with PxPlus 16.20?

My advice is look for differences with the SQL Server and ODBC driver setup since that is where the error is happening.

[Jeffrey Ferreira]

Hi Devon,

both the 16.2 and the 19.1 are querying
      the same SQL database
      using the same dsn
      on the same server


We are in the process of upgrading there pxplus software
the only thing that i can see that has changed is their pxplus version.

do you think i should open a ticket with pxplus?

[Devon Austen]

Considering the error is coming from the Microsoft SQL Server ODBC driver I would still suspect the problem is not the PxPlus version.

Have you confirmed that the ODBC connection made from PxPlus is the same in the 16.2 v 19.1 versions. ODBC connection settings can be set via INI file, link file, prefix file, or directly in the open directive. If the ODBC settings were done in anything other then directly on the open directive it is possible the new version is not matching the old version and that is were the issue is.