Timeout Expired Error - SQL State S1T00 EDL error

• John Fitzgerald-268315

  Old Hand

  Points: 375

  More actions

  February 14, 2006 at 9:27 am

  #67227

  I have a SQL application that is accessed via the Internet. The server that accesses it is a win 2000 server and the app runs on a win 2003 server.

  I sometimes get this error:

  ODBC SQL server driver - Timeout expired SQL State: S1T00 EDL error: An error has occurred in the execution of the ODBC function SQLDriverConnect

  Could this have anything to do with running 2000 server and 2003 server? I can't find any pattern since sometimes it connects with no problems and other times it connect with problem.

  Greatly appreciate any thoughts.

   

   

   

• bledu

  SSChampion

  Points: 12335

  More actions

  February 15, 2006 at 11:07 am

  #621130

  no i don't think that is the problem.

  check your timeout limit.

  i would suggest you use oledb provider for sql, which ms touts as being optimised for sql server, instead of odbc.

  what is the application design like i.e. is it n-tier etc

  if problem persists put more info and will look into the problem

  ---

  Everything you can imagine is real.