Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IdleTimeout setting
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00737850
Message ID:
00741634
Vues:
13
Thanks.

>Hi Ramil,
>
> IdleTimeout?
> (n+1) minutes
>
> If you set IdleTimeOut to 5, then VFP suspend ODBC connection after 6 minutes.
> But under MDAC 2.1 and latter recovering ODBC connection not function correct.
>
> MartinJ
>
>>Hi all,
>>
>>How does the IdleTimeout property work? Assume file paths are correct and they exist, consider the following code snippet:
>>
>>
>>open database cMyTempDBC
>>cDataDBC = 'myDataDBC.DBC'
>>create connection cMyConn connstring "Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB="+;
>>	cDataDBC+";SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
>>*-- set idle timeout to 5 seconds
>>dbsetprop('cMyConn',"connection","idletimeout",5)
>>*-- pause for 10 seconds
>>wait window 'Please wait...' timeout 10
>>*-- create a sql view, this works!
>>create sql view rv_Table1 remote connection connect1 shared as ;
>>	select * from Table1
>>
>>
>>1. Did the IdleTimeout occur?
>>2. Should I not be able to create the view after the connection has been deactivated?
ramil
~~ learning to stand still
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform