>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)
Besides checking on what Mike Levy says, check that the account used to run the nightly job has access permissions on the folders where the DBC resides. If you look up the job history details, it will tell you under which account the job was attempted.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement