We have set up a DTS job on SQL 7.0 selecting in ODBC
the Visual Foxpro driver and selecting file DSN.
We are using MDAC 2.0. The first time we execute the DTS job
it works, the second time it fails, and the system tells us
that it can not find the path to where the DSN file is located
on the server. The ID that created the job and has server has
access has FULL CONTROL on the server and DBO to the job and database.
I have updated the MDAC to 2.1 on a total isolated PC with all the
apps installed and it worked once and failed the second time.