<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div> </div><div style="margin: 0in 0in 0pt;" class="MsoNormal"><font face="Calibri">I am going nuts with this problem and the answer is probably
easy…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></font></div><div>
</div><div style="margin: 0in 0in 0pt;" class="MsoNormal"><font face="Calibri">Situation:<span style="mso-spacerun: yes;"> </span>I have a
large batch file which when executed reads data from MRP (Microsoft SQL Server) and loads it to
our production programs written in a different filePro ODBC 1.0.15. <span style="mso-spacerun: yes;"> </span>This batch file contains 12 processes reading
different tables in MRP.<span style="mso-spacerun: yes;"> </span>Processes run
absolutely correct, when they run.<o:p></o:p></font></div><div>
</div><div style="margin: 0in 0in 0pt;" class="MsoNormal"><font face="Calibri">Here is the problem: When I run the batch file the first
instance where a connection is being made to MRP via a defined data source, it
fails to find the source.<span style="mso-spacerun: yes;"> </span>If I run it
again it works correctly and finds the data source.<span style="mso-spacerun: yes;"> </span>This only happens on the first read of the
day.<o:p></o:p></font></div><div>
</div><div style="margin: 0in 0in 0pt;" class="MsoNormal"><font face="Calibri">I am running this from my workstation, running the batch
file located on one of my servers.<span style="mso-spacerun: yes;"> </span>I set
up the data source first as a user DSN then later as a System DSN.<span style="mso-spacerun: yes;"> </span>I also noticed that the data source (DSN)
does not appear on the server.<span style="mso-spacerun: yes;"> </span>I would
think that since it is a system DSN it would appear there.<o:p></o:p></font></div><div>
</div><div style="margin: 0in 0in 0pt;" class="MsoNormal"><font face="Calibri">Any hints and / or solution would be greatly
appreciated.<span style="mso-spacerun: yes;"> </span>I am going on vacation next
week and want this to run as a scheduled task at night.<o:p></o:p></font></div><div>
</div><div style="margin: 0in 0in 0pt;" class="MsoNormal"> </div><div style="margin: 0in 0in 0pt;" class="MsoNormal"><a href="" name="_MailAutoSig"><span style='mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes;'><font color="#000000"><font face="Calibri">Thank
you in advance,<o:p></o:p></font></font></span></a></div><div>
<span style="mso-bookmark: _MailAutoSig;"><span style='mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes;'><font face="Calibri">Rick Hane<o:p></o:p></font></span></span></div><div>
<span style="mso-bookmark: _MailAutoSig;"><span style='mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes;'><font face="Calibri">Controller<o:p></o:p></font></span></span></div><div>
<span style="mso-bookmark: _MailAutoSig;"><span style='mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes;'><font face="Calibri">Deluxe Stitcher Company Inc<o:p></o:p></font></span></span></div><div>
<span style="mso-bookmark: _MailAutoSig;"><span style='mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes;'><font face="Calibri">ISP Stitching & Bindery Products<o:p></o:p></font></span></span></div><div>
<a href="http://www.deluxestitcher.com/"><font color="#0066cc"><font face="Calibri"><span style="mso-bookmark: _MailAutoSig;"><span style='mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes;'>www.deluxestitcher.com</span></span><span style="mso-bookmark: _MailAutoSig;"></span></font></font></a><span style="mso-bookmark: _MailAutoSig;"><span style='mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes;'><o:p></o:p></span></span></div><div>
<span style="mso-bookmark: _MailAutoSig;"><span style='mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes;'><font face="Calibri">847-455-4400<o:p></o:p></font></span></span></div><div>
</div></div></body></html>