>Hi,
>
>I have a VPF 9 problem here, when i use my program to connect to MSSQL is working file, if i leave it for 1 hours, sometime it show me the error code.
>
>Error loading file - record number 6. FMLVETBL (or one of its members).
>Loading form or the data environment : Connectivity error:
>[Microsoft][ODBC SQL Server Driver]
>Communication link failure
>
>the database connection string is
>DRIVER=SQL Server;uid=sa;pwd=sa;DATABASE=test123;SERVER=test123
>
>the MSSQL is Standard Edition and with Service Pack 2 installed.
>
>Please help. Thank you.
>From Lai Ming Hoe

What is the result of:

? SQLGETPROP(asd,"IdleTimeout")