setting up a filePro ODBC link

[Richard Hane]

Afternoon list,

As I mentioned in an email last week, I am having a problem with our ODBC connection between filePro 5.0.15 ODBC and Microsoft SQL Server.  Workstation is Windows 7 and server is Windows Server 2003.

The batch file that is run has 55 lines.  14 of which run processes that get data from our MRP software written in Microsoft SQL server.  This process has been working for over 2 years.  During the past 2 - 3 weeks we notice the process seems to loose the ODBC link.  As far as we can find, nothing has changed on the workstation or the server.

Trying to trouble shoot this and I have a couple of questions.

If you are running a process that gets data from SQL are you using a System or a User ODBC link?  I would assume System.
Do you run this from a workstation? I have considered setting up the link on the server and running it from there.

I need to get this fixed.  I retired from Deluxe Stitcher on 01/22/2015 and would like to clean this problem up.

Any suggestion would be appreaciated.

Thank you in advance,
Rick Hane
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20150126/4bae95b4/attachment.html>