I am preparing several reports that are run daily for our company in Crystal Reports 10. I am able to open and run the reports on my computer. However, the other report creator must redefine the datasource if he opens the reports on his system. More importantly, if I move the reports to our server and schedule them in Visual Cut, the bat file fails with an error
Main Report Database Connection/Logon Failure
If I open the report within Visual Cut and remap the data source, I can run the report from within Visual Cut, but the bat file still fails.
If the other report creator opens the files on his system in Crystal Reports, remaps the data source and saves the files, then copies them to the server, the bat file will run fine.
It's clear that the problem is some issue with my ODBC driver, but I have deleted and remapped the data source several times to no avail. Any ideas on what to try next?