Loosing fpodbc connection

[Kenneth Brody]

On 3/29/2017 11:25 AM, Richard Hane via Filepro-list wrote:
> Good morning list. Our system: Servers running Windows Server 2003,
> workstation running Windows 7, fp version 5.0.15 R9 and sql 2005. I have
> a process that updates filepro from data (sql) in our MRP program.  This
> batch file runs about 30 fp processes. This has worked for over 10 years.
> In the past week we seem to be loosing the odbc connection.  This seems
> to happen after running one of the longer processes.  This process line
> takes about 10 minutes to run. Is there a timeout setting that I can
> place in the batch file that would extend the time the system keeps the
> odbc connection?  I know I could brake this batch file up in to smaller
> batches but would rather not do that as it would require more user
> input.

In 5.8, filePro's low-level ODBC functions have a new @ODBC.handle.TIMEOUT() 
function to set the timeout.

For high-level ODBC access, there may be a data source specific parameter 
that you can place in the connection string.

-- 
Kenneth Brody