Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    29

    Unanswered: sql timeout error when add or edit a record

    i have sql running on a server and i have about 6 pc accessing the db using a vb project. all of a sudden when ever the user tried to update or addnew data to the db the software would hang and i would get a microsoft sql timeout error. once i stoped and restarted the service everything seems to be fine. does the service need to refreshed on a regular basis? or could someting could of set the db in some sort of lock state?

    if you have any ideas pleas let me know.

    Thanks,
    Thomas

  2. #2
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303

    Arrow me i knew

    Can u give a sample code.

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    put up sql profiler and trace what is going on.
    check if locking or some kind of blocking is happening

Posting Permissions

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