Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IdleTimeout setting
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00737850
Message ID:
00741634
Views:
12
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
Previous
Reply
Map
View

Click here to load this message in the networking platform