4 Replies - 276 Views - Last Post: 26 June 2012 - 06:26 AM Rate Topic: -----

#1 samba007  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 26-June 12

commandtimedout

Posted 26 June 2012 - 02:34 AM

hi the problem occurd at


this error
ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Timeout expired
Is This A Good Question/Topic? 0
  • +

Replies To: commandtimedout

#2 MrShoes  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 312
  • View blog
  • Posts: 488
  • Joined: 13-June 12

Re: commandtimedout

Posted 26 June 2012 - 04:17 AM

So, you're failing to access a database. But what are you doing here?
Was This Post Helpful? 0
  • +
  • -

#3 samba007  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 26-June 12

Re: commandtimedout

Posted 26 June 2012 - 04:25 AM

View PostMrShoes, on 26 June 2012 - 04:17 AM, said:

So, you're failing to access a database. But what are you doing here?

Was This Post Helpful? 0
  • +
  • -

#4 MrShoes  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 312
  • View blog
  • Posts: 488
  • Joined: 13-June 12

Re: commandtimedout

Posted 26 June 2012 - 04:43 AM

I see... much clearer now.

This post has been edited by MrShoes: 26 June 2012 - 04:44 AM

Was This Post Helpful? 1
  • +
  • -

#5 Curtis Rutland  Icon User is online

  • (╯□)╯︵ (~ .o.)~
  • member icon


Reputation: 4480
  • View blog
  • Posts: 7,803
  • Joined: 08-June 10

Re: commandtimedout

Posted 26 June 2012 - 06:26 AM

Well, the first problem is that you're using the ODBC driver for MS SQL Server. Use the native SqlClient provider instead. Next, the problem is that your query is timing out. You should optimize the query so it completes more quickly.
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1