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