Loosing fpodbc connection - Update

[Mike Schwartz]

> Subject: Fw: Loosing fpodbc connection - Update
> 
> 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

     I don't know if this still applies, but years ago, there was a way in Kaspersky Anti-virus to "turn off" virus scanning on certain executable files.  As I recall, Kaspersly was scanning every one of the filePro files (executables, indexes, etcetera) that were being run off of the Windows Server.  This was causing slow-downs opening filepro files to the point that things were timing out.  Again, this was with much older hardware and 10 Mbps networks, but it still may apply.

Hope that helps...

Mike Schwartz