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?