No idea what the cause might be ... network problems or server problems perhaps. That's why I suggested re-trying the query when you get a Timeout exception. It will probably work on the re-try ... this should be acceptable as long as you don't have a really long timeout period.

~~Bonnie



>l let it timeout and this is what I got
>
>Message="Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
>
>I've not altered anything and this was working a few minutes ago and has now stopped again.
>
>Any thoughts on how to track down the cause ?
>
>Nick
>
>
>>Hey Nick,
>>
>>OK, so there's probably an intermittent connection problem. Is the database server on your own machine or on the network?
>>
>>Here's what I'd do:
>>
>>1) shorten the timeout period
>>2) wrap it in a try/catch
>>3) put the try/catch in a loop for maybe 2 or 3 times
>>
>>Since the problem seems to be intermittent, I think that it will probably go through ok when you re-try it.
>>
>>~~Bonnie
>>
>>
>>
>>>Hi Bonnie
>>>
>>>There is a long time out and eventually it will. But there isn't really a lot of helpful information in the timeout message.
>>>
>>>The query isn't long as exactly the same one is now working ok (again).
>>>
>>>Nick
>>>
>>>
>>>
>>>>If it's intermittent and it happens on the same query, then it has to be either connection problems or a timeout on a long query. Have you tried putting the .Fill() in a try/catch? Does it generate an exception at all? It should at least do that. If there is no exception being thrown, then perhaps you have a very long timeout setting and it appears to hang or freeze so you end up killing it before the timeout period is over.
>>>>
>>>>~~Bonnie
>>>>
>>>>
>>>>
>>>>
>>>>>HI
>>>>>
>>>>>I'm using a mysql database to do some reporting.
>>>>>
>>>>>I seem to be having a problem with my data connection intermittently hanging up or freezing.
>>>>>
>>>>>I know the mysql database is responding because I can set the same query off in the mysql query browse and it runs ok.
>>>>>
>>>>>I can see that its hanging on the line adapter.fill(dt) below
>>>>>
>>>>>Dim adapter As MySqlDataAdapter = New MySqlDataAdapter(sqlCmd)
>>>>> Dim dt As DataTable = New DataTable
>>>>>
>>>>> adapter.Fill(dt)
>>>>>
>>>>> Return dt
>>>>>
>>>>>Anyone got any tips on how to diagnose this problem. I
>>>>>
>>>>>I can't get a handle on where to look at the moment.
>>>>>
>>>>>The annoying thing is it seems to to be intermittent so I'm finding it hard to track the cause.
>>>>>
>>>>>I thought it might be the server so I restarted that.
>>>>>.
>>>>>Thanks