I have a VFP9 app that's communicating with DB2 tables via ODBC.
I use this command to do that of course:
plnConnectionHandle = SQLSTRINGCONNECT(lnConnectionString)
...my problem is (or I *think* my problem is) that after a while this connection is no longer valid - I'm assuming it simply times out because the app doesn't use these tables much. What is a recommended way I can test to see if the connection is still good, and if not reconnect?
Thanks!
ICQ 10556 (ya), 254117