SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 "Object was open" DB Error
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

gpatriarca
Starting Member

Canada
3 Posts

Posted - 10/21/2004 :  16:33:54  Show Profile
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!


Edited by - gpatriarca on 10/21/2004 16:42:21

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 10/21/2004 :  16:45:08  Show Profile  Visit tkizer's Homepage
Does the stored procedure work in Query Analyzer?

Tara
Go to Top of Page

gpatriarca
Starting Member

Canada
3 Posts

Posted - 10/21/2004 :  16:52:43  Show Profile
quote:
Originally posted by gpatriarca

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.



Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 10/21/2004 :  16:54:07  Show Profile  Visit tkizer's Homepage
I'd suggest posting this on a PowerBuilder forum then.

Tara
Go to Top of Page

gpatriarca
Starting Member

Canada
3 Posts

Posted - 10/21/2004 :  16:56:54  Show Profile
Thanks Tara.
Go to Top of Page

pvedi
Starting Member

USA
6 Posts

Posted - 05/21/2007 :  17:13:03  Show Profile  Send pvedi a Yahoo! Message
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...
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000