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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only