Fw: Loosing fpodbc connection - Update

[Richard Hane]

Update
It looks like we may have found the problem although I would be interested if there is a variable for the timeout.
The problem may be with our antivirus software (Kaspersky).  We have used this program for over 10 years; however, a receipt update has caused problems with other sql software.  Pausing (temp. turning it off) the Kaspersky seems to allow it to run.  It evens seems to run a little faster.
Has anyone else found this problem?
Thank youRick Hane


     On Wednesday, March 29, 2017 10:26 AM, Richard Hane via Filepro-list <filepro-list at lists.celestial.com> 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.
I would appreciate any suggestions.
Thank you in advance,Rick HaneYore Software 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170329/e61964bb/attachment.html>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170329/5998e428/attachment.html>