We have COTS license system and we do not own or have the source code. The system print licenses, and endorsements from an icon the user presses.
We upgraded from SQL 2000 to SQL 2005 and now it does not print the endorsements. We moved back to 2000 for testing and it works fine so the problem is definately 2005 related.
We are running 2005 with SP3.
We set a trace and the exact same command is created for both versions.
The command is executed via sp_cursoropen.
There appears to some info on the internet about blocking, and problems with sp_cursoropen prior to the latest service pack, but I am unable to nail down the problem.
Any ideas? It is a WIN32 Powerbuilder app.
Jim
We upgraded from SQL 2000 to SQL 2005 and now it does not print the endorsements. We moved back to 2000 for testing and it works fine so the problem is definately 2005 related.
We are running 2005 with SP3.
We set a trace and the exact same command is created for both versions.
The command is executed via sp_cursoropen.
There appears to some info on the internet about blocking, and problems with sp_cursoropen prior to the latest service pack, but I am unable to nail down the problem.
Any ideas? It is a WIN32 Powerbuilder app.
Jim
