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