<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div><span>Thank you to Walt and Bob,</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;"><span>I think my course of action tomorrow will be first to remove any anti virus from the work station and try it.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color:
transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;"><span>If that does not work then I will move the batch file to the server, create the system ODBC link there and try it.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;"><span>I will report back as to my success or lack there of. Just in case any others run in to this.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family:
HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;"><span>Thank you,</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;"><span>Rick Hane</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;"><span><br></span></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: HelveticaNeue, 'Helvetica
Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 16px;"> <div dir="ltr"> <font size="2" face="Arial"> On Tuesday, January 27, 2015 2:32 PM, Bob Haussmann <haussma@nextdimension.net> wrote:<br> </font> </div> <br><br> <div class="y_msg_container">Richard--we use ODBC low-level on some daily processes. I'm afraid I don't<br clear="none">have much to offer you in this case, however. We do run our fp process on<br clear="none">the server though--it has been rock solid for a number of years (from SQL<br clear="none">2005 through 2012).<br clear="none"><br clear="none">Bob<br clear="none"><div class="yqt6413941885" id="yqtfd13334"><br clear="none">-----Original Message-----<br clear="none">From: Filepro-list<br clear="none">[mailto:filepro-list-bounces+haussma=<a shape="rect"
ymailto="mailto:nextdimension.net@lists.celestial.com" href="mailto:nextdimension.net@lists.celestial.com">nextdimension.net@lists.celestial.com</a>]<br clear="none">On Behalf Of Richard Hane<br clear="none">Sent: Tuesday, January 27, 2015 12:36 PM<br clear="none">To: FilePro Mailing List<br clear="none">Subject: Fw: setting up a filePro ODBC link<br clear="none"><br clear="none">I sent the email below yesterday. Does anyone other than me run the ODBC<br clear="none">low level from filePro?<br clear="none"><br clear="none">Thank you in advance<br clear="none">Rick Hane<br clear="none"><br clear="none"><br clear="none"><br clear="none">On Monday, January 26, 2015 3:21 PM, Richard Hane <<a shape="rect" ymailto="mailto:yoresoft@sbcglobal.net" href="mailto:yoresoft@sbcglobal.net">yoresoft@sbcglobal.net</a>><br clear="none">wrote:<br clear="none"> <br clear="none"><br clear="none"><br clear="none">Afternoon list,<br clear="none"><br
clear="none">As I mentioned in an email last week, I am having a problem with our ODBC<br clear="none">connection between filePro 5.0.15 ODBC and Microsoft SQL Server.<br clear="none">Workstation is Windows 7 and server is Windows Server 2003.<br clear="none"><br clear="none">The batch file that is run has 55 lines. 14 of which run processes that get<br clear="none">data from our MRP software written in Microsoft SQL server. This process<br clear="none">has been working for over 2 years. During the past 2 - 3 weeks we notice<br clear="none">the process seems to loose the ODBC link. As far as we can find, nothing<br clear="none">has changed on the workstation or the server.<br clear="none"><br clear="none">Trying to trouble shoot this and I have a couple of questions.<br clear="none"><br clear="none">If you are running a process that gets data from SQL are you using a System<br clear="none">or a User ODBC link? I would
assume System.<br clear="none">Do you run this from a workstation? I have considered setting up the link on<br clear="none">the server and running it from there.<br clear="none"><br clear="none">I need to get this fixed. I retired from Deluxe Stitcher on 01/22/2015 and<br clear="none">would like to clean this problem up.<br clear="none"><br clear="none">Any suggestion would be appreaciated.<br clear="none"><br clear="none">Thank you in advance,<br clear="none">Rick Hane<br clear="none">-------------- next part --------------<br clear="none">An HTML attachment was scrubbed...<br clear="none">URL:<br clear="none"><<a shape="rect" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20150126/4b" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20150126/4b</a><br clear="none">ae95b4/attachment.html><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing
list<br clear="none"><a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none">-------------- next part --------------<br clear="none">An HTML attachment was scrubbed...<br clear="none">URL:<br clear="none"><<a shape="rect" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20150127/f0" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20150127/f0</a><br clear="none">f86d76/attachment.html><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a shape="rect"
ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none"><br clear="none"><br clear="none"><br clear="none"></div><br><br></div> </div> </div> </div> </div></body></html>