I am working with a PowerBuilder 9 window which contains two datawindow objects and originally have embedded SQL. I transformed the two datawindow objects to use stored procs in MS SQL Server 2000. When I run the application to insert a new row, I got the ff. error message:
A database error has occurred. Database error code: 999 Database error message: Microsoft OLE DB Provider for SQL Server Object was open. No changes made to database. execute dbo.p_inert_data;1
I am working with a PowerBuilder 9 window which contains two datawindow objects and originally have embedded SQL. I transformed the two datawindow objects to use stored procs in MS SQL Server 2000. When I run the application to insert a new row, I got the ff. error message:
A database error has occurred. Database error code: 999 Database error message: Microsoft OLE DB Provider for SQL Server Object was open. No changes made to database. execute dbo.p_inert_data;1
Please help how I can solve this problem. Thanks!
REPLY: Yes, the stored procs (two of them, one for each datawindow object) work in Query Analyzer.
Make sure that the Declare <localPRocName> for PROCEDURE USING SQLCA... is not first line in the code, if it is the first line then before this line decalare a local dummy variable. I think PB takes the first semicolon of the declaration and thinks there is an ancestor script and try to execute Declare line as ancestor call...
"Object was open" DB Error
Forum Locked
Posted - 10/21/2004 : 16:33:54
