Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    Singapore
    Posts
    1

    Question Unanswered: Getting error MS SQL2000

    Hi ,

    In one of our vendor's prog [VB], we always got this error when it try to assign seq number.

    The whole process will run around 5 hrs and the last 5 minutes is the seq number assigning part.

    [Microsoft][ODBC SQL Server Driver]Timeout expired

    But using the same program etc..., when we re run the seq no assiigning only, it is fine.

    Can some body help me to clear this.

    thanks

    rgs
    ananth [Microsoft][ODBC SQL Server Driver]Timeout expired

  2. #2
    Join Date
    May 2002
    Location
    Cape Town , South Africa
    Posts
    30

    Getting error MS SQL2000

    HI ,

    what did you set you connection time to , e.g. for the program to connect to the sql server?did you try setting it higher e.g. from 30 seconds to 60 seconds?

Posting Permissions

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