Database Error Code 999 Sybase
links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center. Forums Archive > PowerBuilder > Database > "Database error code : 999 SQL Native Client Object was Open" Database error code : 999 SQL Native Client Object was Open 3 posts in Database . Last posting was on 2009-01-07 14:10:56.0Z Sandeep Posted on 2008-12-15 16:14:37.0Z Sender: 375f.494681a2.1804289383@sybase.comFrom: sandeepNewsgroups: sybase.public.powerbuilder.databaseSubject: Database error code : 999 SQL Native Client Object was OpenX-Mailer: WebNews to Mail Gateway v1.1tMessage-ID: <4946826d.3787.1681692777@sybase.com>NNTP-Posting-Host: 10.22.241.41X-Original-NNTP-Posting-Host: 10.22.241.41Date: 15 Dec 2008 08:14:37 -0800X-Trace: forums-1-dub 1229357677 10.22.241.41 (15 Dec 2008 08:14:37 -0800)X-Original-Trace: 15 Dec 2008 08:14:37 -0800, 10.22.241.41Lines: 10Path: forums-1-dub!not-for-mailXref: forums-1-dub sybase.public.powerbuilder.database:29696 Article PK: 311908 I am getting following error Database error has occurred. Database error code : 999 Database error message: Select Error: Mircosoft SQL Native Client Object was Open. thanks Jim Madderra Posted on 2008-12-16 00:28:39.0Z From: "Jim Madderra"
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Database error code 999 Want to Advertise Here? Solved Database error code 999 Posted on 2004-01-27 http://nntp-archive.sybase.com/nntp-archive/action/article/%3C4946826d.3787.1681692777@sybase.com%3E Sybase Database 1 Verified Solution 4 Comments 4,370 Views Last Modified: 2007-12-19 Using Windowx XP Professional The application name is VISS VISS is a power builder application . Actually using powerbuilder database. Tried couple of times and still getting this error. can u help me in figure otu what's the problem? I am not able to paste https://www.experts-exchange.com/questions/20864653/Database-error-code-999.html that dislog box for the screen shot. but i am writing it down the error message which appears on the dialog box. i am getting this dialog box where the error says on the top of the dialog box on the blue bar. title is Virtual Information Service System. database error code 999 database error message: select error: SQLSTATE=S1000 [Asgard Software][Open/A] THE TABLE 'SALE-BY-ORD-NR' MAY NOT BE ACCESSED BY VISS How to resolve this error ? I don't know here the error is? looks like Its a database problem If u can help me figure out today. Thanks. Manisha. 0 Question by:mmontu Facebook Twitter LinkedIn Google LVL 15 Best Solution bynamasi_navaretnam I think the table 'SALE-BY-ORD-NR' has been deleted or the definition of it has changed. Ask your DBA about it. It may be possible that select permission is not granted on that table or even the Go to Solution 2 Comments Message Author Comment by:mmontu2004-01-27 If u can help me to solve this error today. I thin
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your http://www.tek-tips.com/viewthread.cfm?qid=939091 Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below database error into your site. Sybase: PowerBuilder Forum at Tek-Tips HomeForumsProgrammersDevelopment ToolsSybase: PowerBuilder Forum "Object was open" database error thread144-939091 Forum Search FAQs Links MVPs "Object was open" database error "Object was open" database error wpgmb (Programmer) (OP) 22 Oct 04 11:34 I'm working on a PB 9 window containing two datawindow objects (DWO). The DWOs originally have embedded SQL. I have converted them to use insert stored procedures (SP)in MS SQL Server 2000 (one database error code stored proc for each DWO). I have tested the SPs in SQL Query Analyzer and they worked. But when I run the application I got the ff. error:A database error has occurred.Database error code: 999Database error message:Microsoft OLE DB Provider for SQL ServerObject was open.No changes made to database.execute dbo.p_insert_data;1Please help! THANKS!! RE: "Object was open" database error bubbly (Programmer) 25 Oct 04 01:46 Hi,R u using Cursors in SP, in that case u need to Close and deallocate the cursor.... when u execute in a single user environment it works.. but in multiple user envronment it gives out this error..Check it out and let me know in case u still face the same problemRegardsAnjali RE: "Object was open" database error wpgmb (Programmer) (OP) 25 Oct 04 10:30 Hello,Thanks for your reply.I'm not using cursors in SP. In this PB 9 window with two DWOs, two insert SPs are supposed to be executed one after the other when the user saves the data. The first insert SP executes but when executing the second insert SP, I got the "Object was open" error.Thanks,Gil RE: "Object was open" database error bubbly (Programmer) 26 Oct 04 02:49 http://pb.besoft.com.cn/download/ebf/PB803mr_fixes...Check it out here... u need to update the patch for this fix. Red Flag This Post Please let us know here why th
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 05:50:45 GMT by s_hv972 (squid/3.5.20)