Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC looses connection after a while
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01587574
Message ID:
01587584
Vues:
41
>>>If I'm looking for reliability I have connections open only the bare minimum amount of time needed to communicate with the backend. It used to be expensive to frequently connect and disconnect like that, but my understanding is modern versions of RDBMSs cache or pool connections so there's not much impact.
>>
>>Yes, this is what I recommanded. But, I was just trying to see if this is a normal behavoir that it reacts like that.
>
>Check DispLogin property
>
>SQLSETPROP(0,"DispLogin",3)
>
>There is another one, I think. Try Searching this site, I forgot at the moment.

See
Message #1550872
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform