Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Test for active ODBC connection???
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Test for active ODBC connection???
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01560631
Message ID:
01560631
Vues:
76
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform