I have a process that uses PlanetPress Database ODBC connection to a foxpro .dbf file that is located in a shared folder on another machine.

this is the connection string: DSN=PlanetPress;UID=;PWD=;SourceDB=\\10.0.0.2\DDMS\W1;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;
then:
SELECT * FROM af-master.dbf WHERE af_Status <> 'S'

The problem is when the 10.0.0.2 is rebooted, PlanetPress can't access the AF-MASTER.DBF until we reboot PlanetPress machine.

Both machines are running Win2008 Server. They are on a workgroup, not domains.

Here's what I've extracted from the logs:
------------------------------------------------------------------------
LAST SUCESSFULLY SENT E-MAIL THROUGH AF-MASTER PROCESS
------------------------------------------------------------------------
WPROC: AF-Master - 17:30:40
Blah
blah
WPROC: AF-Master complete - 17:30:56
------------------------------------------------------------------------
THIS IS WHERE IT WAS HANDED OFF TO PPIMAGE
------------------------------------------------------------------------
REQST: PPImage Request - 17:30:58
INFO: Processing file C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Image\QueuedJobs\5C8C44B.ps
DEBUG: Reading job options from input file
DEBUG: Watch Process Name : AF-Master
INFO: Starting conversion...
INFO: Initializing PlanetPress Alambic...
INFO: Distilling file to 576840-0.pdf...
INFO: Conversion completed successfully.
INFO: Starting SMTP email....
INFO: Sent to: XXXXXXXXXXXXXXX
INFO: SMTP mail sent successfully.
INFO: Process completed successfully.
REQST: End time: 17:30:59
DEBUG: Adding job to queue: C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Image\QueuedJobs\5E3CA52.ps
------------------------------------------------------------------------
PPWATCH GOES BACK TO *NORMAL* MONITORING OF THE AF-MASTER.DBF
------------------------------------------------------------------------
WPROC: AF-Master - 20:00:12
INFO : File created : C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Watch\Spool\12.tmp\job00ZKLPKR32I3L376516587.dat, size: 25 bytes
INFO : Plugin Create File completed successfully - 20:00:12
INFO : File processed : job00ZKLPKR32I3L376516587.dat, size: 311 bytes
INFO : Plugin PlanetPress Database completed successfully - 20:00:12
INFO : Splitting 1 records and/or 1 pages per split
INFO : No pieces left.
INFO : Plugin Database Splitter completed successfully - 20:00:12
WPROC: AF-Master complete - 20:00:12
------------------------------------------------------------------------
------------------------------------------------------------------------
SERVER REBOOTS FOR DAYEND AT 8PM....CAUSING “AF-MASTER.DBF DOES NOT EXIST” MESSAGE FOR THE NEXT 4 MINUTES.
------------------------------------------------------------------------
------------------------------------------------------------------------
WPROC: AF-Master - 20:00:22
INFO : File created : C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Watch\Spool\12.tmp\job00ZKLPKSQVJSC616518CB6.dat, size: 25 bytes
INFO : Plugin Create File completed successfully - 20:00:22
ERROR: W3612 : Error running SQL: [Microsoft][ODBC Visual FoxPro Driver]File 'af-master.dbf' does not exist
ERROR: PlanetPress Database: W1603 : Plugin failed - 20:00:22
ERROR: W3001 : Error while executing plugin: W3835: The emulation is not database
ERROR: Database Splitter: W1603 : Plugin failed - 20:00:22
INFO : File processed : job00ZKLPKSQVJSC616518CB6.dat, size: 25 bytes
INFO : Plugin Change Emulation completed successfully - 20:00:22
INFO : JobInfo/Variable %{FxFileName} is set to ""
INFO : JobInfo/Variable %{Af_Status} is set to ""
INFO : JobInfo/Variable %{af_Type} is set to ""
INFO : JobInfo/Variable %{af_Comment} is set to ""
INFO : JobInfo/Variable %{Af_FaxNumber} is set to ""
INFO : JobInfo/Variable %{af_Subject} is set to ""
INFO : JobInfo/Variable %{af_ToAddress} is set to ""
INFO : Plugin Set Job Infos and Variables completed successfully - 20:00:22
INFO : is equal to : false
INFO : Condition result is false
INFO : Plugin Text Condition completed successfully - 20:00:22
INFO : Deleting file : job00ZKLPKSQVJSC616518CB6.dat, size: 25 bytes
INFO : Plugin Delete completed successfully - 20:00:22
WPROC: AF-Master complete - 20:00:22
------------------------------------------------------------------------
------------------------------------------------------------------------
SERVER IS NOW BACK UP...”AF-MASTER.DBF..” ERROR GOES AWAY. LOG LOOKS *NORMAL* AGAIN
------------------------------------------------------------------------
------------------------------------------------------------------------
WPROC: AF-Master - 20:04:15
INFO : File created : C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Watch\Spool\12.tmp\job00ZKLPLVATFK3AA6551B6B.dat, size: 25 bytes
INFO : Plugin Create File completed successfully - 20:04:15
INFO : File processed : job00ZKLPLVATFK3AA6551B6B.dat, size: 311 bytes
INFO : Plugin PlanetPress Database completed successfully - 20:04:15
INFO : Splitting 1 records and/or 1 pages per split
INFO : No pieces left.
INFO : Plugin Database Splitter completed successfully - 20:04:15
WPROC: AF-Master complete - 20:04:15
------------------------------------------------------------------------
------------------------------------------------------------------------
AF-MASTER PROCESS CONTINUES RUNNING W/OUT ERRORS BUT IS NOT READING THE QUOTE SUBMITED AT 21:10.
------------------------------------------------------------------------
------------------------------------------------------------------------
WPROC: AF-Master - 21:10:04
INFO : File created : C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Watch\Spool\12.tmp\job00ZKLQ40FSVC3C16915F46.dat, size: 25 bytes
INFO : Plugin Create File completed successfully - 21:10:04
INFO : File processed : job00ZKLQ40FSVC3C16915F46.dat, size: 311 bytes
INFO : Plugin PlanetPress Database completed successfully - 21:10:04
INFO : Splitting 1 records and/or 1 pages per split
INFO : No pieces left.
INFO : Plugin Database Splitter completed successfully - 21:10:04
WPROC: AF-Master complete - 21:10:04
------------------------------------------------------------------------
PLANETPRESS DOES NOT PROCESS THE JOBS QUEUED IN AF-MASTER UNTIL WE REBOOT THE PLANETPRESS MACHINE (OR RESTART PLANETPRESS).