We have a web application that is used to enter data that will be stored into a Foxpro DBC. The data is stored in a SQL datawarehouse. I have a Foxpro process that opens up the SQL table using a remote view, processes the records and updates the Foxpro DBC. We are attempting to automate process by adding it to the nightly jobs, but whenever we attempt to run it on any other system, we're getting an OBDC error.

The remote view is defined in the Foxpro DBC, but apparently that's not enough. What are my options for resolving this? Is there some way and can create/encapsulate the OBDC connection in the process? (I haven't worked much with this client/server stuff)