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