Help with fpODBC

[Richard Hane]

Good morning list,

I posted the email below to the list several weeks ago and did not receive  many responses.  I need some one very soon to help do to thing on our system.  We are willing to pay for this.

1. Need help setting up the ODBC link.

2. Set up the update on 1 simple file we have so I understand the process.  I can take it from there.

I have to believe there are those out there who use the ODBC portion of filePro.

Thank you in advance,
Rick Hane
Controller
Deluxe Stitcher Company Inc
ISP Stitching Products
www.deluxestitcher.com
rhane at deluxestitcher.com
773-777-6500

Earlier email posted to the list 3 weeks ago.

We have a 3 server Win 2003 network and we are using fpODBC (16 user).  Version in rcabe is 5.0.15R9.
Each morning I update 15 Excel spreadsheets using an ODBC link to our ERP software written in Microsoft SQL Server.
I then run a process to update all our fp files.  This hole process takes me between 30 and 45 minutes.  Way too long.
Obvious question....  why not use the fp and link directly to the SQL Server.
Well to be blunt, I took the class in Indy 5 or 6 years ago.  And just recently tried to set up the link and get this working.
I can not get the link to work and have forgotten anything I would have learned in the class.
If you are in the Chicago area and know how to do the above; I would be interested in discussing paying you to come in and get this working.
If you are interested please contact me at the email address below.
Thank you,
Rick Hane
Controller
Deluxe Stitcher Company Inc
ISP Stitching Products
www.deluxestitcher.com
rhane at deluxestitcher.com
773-777-6500
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120308/58623caa/attachment.html