Results 1 to 3 of 3

Thread: Time out errors

  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: Time out errors

    Hi,
    We have an application connects to the database server, recently at times it gives "Error in OpenConnection ()
    TimeOut Expired" Error.
    I tried to put profiler and found that
    "Error: 16945, Severity: 16, State: 1"
    "Error: 16937, Severity: 16, State: 1"
    are currently occuring on the server at some regular intervals and at that time connection timeout expired error
    comes.
    the above two cursors talk about cursors, but the procedures that the application is trying to use does not have any
    cursors.
    any help would be highly appreciated.
    regards,
    Harshal.

  2. #2
    Join Date
    Mar 2004
    Location
    Dubai
    Posts
    29

    Arrow

    Hi ,
    I used to get some timed out errors similar to this when my application server and SQLServer were on 2 machines.
    When i moved both to a single machine i stopped getting it.
    I suspect its something to do with the network.

    Regards

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    i dont think its a network related issue.
    error 16937 refers to "A server cursor is not allowed on a remote stored procedure or stored procedure with more than one SELECT statement. Use a default result set or client cursor."
    but the stored procedure that is been called has only one select statement in it.
    still i get this error.
    any thoughts?
    regards,
    Harshal.

Posting Permissions

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