[Microsoft][ODBC SQL Server Driver] Timeout Expired

• Molly-602811

  SSC Veteran

  Points: 232

  More actions

  January 24, 2008 at 9:50 am

  #127639

  [Microsoft][ODBC SQL Server Driver] Timeout Expired

  Hi can anyone help me, i am getting the above error when a running view.

  Even if changing the timeout as unlimited still i get the same error if i run that view.

  plz help

  Thanks

  Molly

• avinashdhongade

  Valued Member

  Points: 65

  More actions

  January 26, 2008 at 10:12 am

  #772132

  In order to configure timeouts for SQL Server Driver using ODBC connection

  using DSN, click

  Contol Panel --> Administrative Tools --> Data Sources (ODBC)

  Choose your connection (User DSN/System DSN)

  Choose the Data Sources --> Configure

  At the fourth page of the configuration window

  Tick the option for "Save long running queries to the log file:"

  Once tick, there's a field called "Long queries time (miliseconds):"

  The default value is 30000 miliseconds.

  Hope this helps..