NO

I see the point but thats not going to work.

This seems to be happening for extended periods of several minutes.

I'm not positive but it only seems to be happening on stored procedure calls.


>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