Information générale
Titre:
Connection problems
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement