I am using Crystal Reports 7 and am using ODBC to connect to an Oracle 8i database. I have 4 webservers running my reports and two work fine but were set up over a year ago. We added to new web servers to the pool and we see the error: "Database Connection Fails. Please ensure that database is in location specified in report." I have no idea what the problem is for this because these reports do work on the older web servers. Also some reports do work on the newer web servers, but they are only reports that access one table in the database. We access the reports through a url passing the parameters. Any that require the use of more than one table give me this failed error message. Does anyone have any ideas or suggestions.
[sig][/sig]
[sig][/sig]