this is getting ridiculous. the above "solution" obviously didn't work because i needed to send a ping command to the actual mysql server--not just the server itself. here's the code for doing just that:
when using vba (or visual basic, etc) there is a dll that can be downloaded
HERE - Public Sub Ping_MySQL()
-
-
On Error GoTo PingError
-
Set GCnn = New MYSQL_CONNECTION
-
GCnn.OpenConnection "xx.xxx.xx.xx", "your db name", "your password", "user name"
-
If GCnn.State = MY_CONN_OPEN Then
-
GCnn.ping
-
Debug.Print "connection successfully pinged " & Now()
-
Else: Debug.Print "ping command unavailable"
-
End If
-
Set GCnn = Nothing
-
Exit Sub
-
PingError:
-
Debug.Print "ping error"
-
Exit Sub
-
End Sub
-
-
'if u're using this code, don't forget to add the VBAMySQL.dll in your references
BUT
the problem still remains. i'm not sure if the problem is b/c i'm using an odbc connection and pinging it using a different method. i thought it would work since the ping command was coming from the same ip address. there have been a few times where i've been able to restore the connection using that function but others i can call that procedure all i want and it doesn't do any good. the conclusion i'm coming to is there is an additional problem. HELP?
so...
SOS
i'm running out of time to get this problem fixed. i've looked into populating a continuous form using command lines programmed into the dll--which would be similar to using DAO or ADO but programming a continuous form looks to be very painful if not near impossible since no one else has had the need to do it before. can ANYBODY throw me a lifeline here? i would very much appreciate it.