Results 1 to 3 of 3

Thread: DB Error Help Prepared Statements

Hybrid View

  1. #1
    Join Date
    Jan 2010
    Posts
    37
    Are you the DBA for the Sybase machine? It sounds like someone defined a resource govenor resource group assigned your database to it and you are trying to exceed the limitations defined in the group. I would talk with the DBA for the database server to start researching what is definied for resource govenor.

  2. #2
    Join Date
    Mar 2006
    Location
    Indiana
    Posts
    5
    After quite a few searches, I finally found where to set the max allowed cursors and max allowed statements in Sybase.
    That gets me arround the error message, but now my problem is understanding why I had more than 50 prepared statements in the first place.
    I use only one ADO db connection and close each recordset after uses. I rarely have more than one recordset open at any time and never more than three.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •