Post reply

[Microsoft][ODBC SQL Server Driver]Timeout expired

  • July 3, 2005 at 10:15 pm

    #167705

     Hello,

    I have a problem here. When I'm testing my program on a stand-a-lone PC, everything goes fine. However, when I try to package the program and install it in a workstation. An error message come out, saying that "[Microsoft][ODBC SQL Server Driver]Timeout expired". Why is this so?

    The program is using VB6, MSDE 7.0 and using ODBC connection. So far, all other PCs are OK. Connection between the client PC and the server is OK as well. I don't know why this error message coming out when I'm trying to execute one of the page.

    I tried to use Service Pack 4 (latest Service Pack) and there's of no help. Then I try to use CmmandTimeOut and there's no help either.

    Anyone who knows the solution for it, please do let me know.

    Thanks and regards

  • July 5, 2005 at 1:27 am

    #570800

    http://support.microsoft.com/kb/313661/EN-US/




    My Blog: http://dineshasanka.spaces.live.com/

  • July 7, 2005 at 1:43 pm

    #572071

    I had this problem lot of time.

    If 2 users are connected using same data. it might be locked for one, as Access is designed the way that it puts page lock instead of row lock even when you are connected to one record.

    Hope this help.

  • July 7, 2005 at 8:32 pm

    #572149

    For Dinesh,

    I have installed the latest Service Pack for SQL Server before I post the message earlier on but it does not work.

    Anyhow, I have solve the problem with MDAC 2.8 SP1.

    Thanks and regards.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply