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