Comparing Text Files on the Server

[rpolunsky]

I have a comparison report using the Microsoft Text driver; I run extraction reports from two different databases exporting the results to a text file, then run the comparison report to find out where I have discrepancies between the two.

I can do all of this in my local workstation just fine. I can schedule the extraction reports to text file output in the Seagate Info 7 scheduler and that works just fine. I cannot, however, get the comparison reports to work when scheduled.

I rather believe I'm going to have to make sure there are exactly analogous drive/directory combinations to put the text files in so that the ODBC entry on the server for the text file driver will match the one on my workstation.

Has anyone out there ever tried something like this?

Richard A. Polunsky
Houston, Texas

 

[AEldridge]

Hi Richard,

It's going to be something to do with either the setup of the ODBC DSN or the access rights on the files. Check out the FAQ in the Crystal Enterprise forum... howeverin SI is that the report is run by the rptagnt32, which is forked by the Sentinel service. Therefore, try running the Sentinel service under a named user ID.

Hope this helps.

Cheers, Alan Eldridge
Melbourne, Australia