Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Test for active ODBC connection???
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Test for active ODBC connection???
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01560631
Message ID:
01560631
Views:
75
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
Next
Reply
Map
View

Click here to load this message in the networking platform