Post reply

getting the error "odbc sql server driver timeout expired"

  • May 5, 2009 at 7:18 am

    #93468

    Hi ALl,

    When i am trying to run the query from UI (to SQL) , getting the error "odbc sql server driver timeout expired".

    Please provide me the reason for this issue and how to handle these issues.

  • May 5, 2009 at 9:39 am

    #988966

    One reason could be the query you trying to execute takes a long time and the driver is timing out waiting for the response from the SQL Server. The default value is several minutes (I do not remember exactly - it was a while ago when I used ODBC) so if your query is executing quickly in Management Studio then maybe the UI timeout value was set to a much smaller value - check if your code is setting the timeout values.

    ---------------------------------------------
    [font="Verdana"]Nothing is impossible.
    It is just a matter of time and money.[/font]

  • May 6, 2009 at 2:30 pm

    #989951

    I have seen the same problem here where some Access "applications" were used as front ends for the MSSQL tables. There is a timeout field that you can set. Don't make the same mistake we did and set it really high. Set it to 0 (my experience in Access) and it will disable time out.

    What kind of UI is it?

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

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