Powerbuilder 10.5 using SQL Server 2000 ERROR

[flwk69]

I have been receiving the following SQL Server error message:

Using PowerBuilder 10.5 inherited window that contains one datawindow object that is calling a stored procedure in MS SQL Server 2000 (but runing in sql server 6.5 compatibility mode). When I execute a datawindow retrieve the following error is displayed. This is happening everywhere in the application not just one datawindow. It does not occur in PowerBuilder 7.0.

A database error has occurred.
Database error code: 999
Database error message:
Microsoft OLE DB Provider for SQL Server
Object was open.Error while updating. Please refresh window..

Please advise on how I can solve this problem. Thanks!

 

[mbalent]

Have you run a trace on the DB to see what statement is being executed by the datawindow?

Matt

"Nature forges everything on the anvil of time