I considered that - but it takes a few seconds to actually make the connection - so I don't want to have to disconnect/reconnect if I don't have too.
>The best way is to use SQLIDLEDISCONNECT() and let VFP handle it
>
>>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