Help on fpODBC

[Richard Hane]

Good afternoon list,
 
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/20120220/7597a759/attachment.html