[NEWSENDER] - Re: Fw: Looking for a couple hours of help (fp) - Message is from an unknown sender

[Rick Hane]

Ken,

You may be correct.  Here is the situation.  Our MRP software runs under
Microsoft SQL Server SQL(7).  Been in place operational for over 12
years. I know ODBC works on it as each night I update 13 Excel
spreadsheets which have odbc link to this database.  Then I save them as
dif files and run a batch file of about 20 processes that update fp.
Again this has been in place for over 8 years.  I know fpodbc can do the
same.  I even took the class in Indy.  I just don't have the time to
open the manual and refresh this old brain.

I know the path to the SQL database.  Maybe someone could walk me
through setting up fp to read that link and update.  I just don't know.

Any thoughts out there? 
 
Thank you,
Rick Hane,
Controller
DeLuxe Stitcher Company
www.deluxestitcher.com
773-777-6500 ext 13
 
 

-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Monday, August 02, 2010 11:40 AM
To: Richard Hane
Cc: filepro-list at lists.celestial.com; Rick Hane
Subject: [NEWSENDER] - Re: Fw: Looking for a couple hours of help (fp) -
Message is from an unknown sender

On 8/2/2010 11:41 AM, Richard Hane wrote:
> I assume from the lack of responses that either there is no one in the

> Chicago area who is familar with setting up a fpodbc (5.0.15) with SQL

> Server database or no one one needs the extra billing.
[...]

Do you really need the person on-site?  It may be that the people with
such experience aren't in the Chicago area, and so they didn't respond.

Is MS SQL Server already installed and configured?  If so, must the
person have specific MS SQL Server ("SQL7" according to your OP)
experience, or would fPODBC experience with other (non-MS) SQL servers
be sufficient?

--
Kenneth Brody