We are currently running a number of reports written in crystal 7 on our web server (IIS 5.0 on W2K adv server) that connect to our SQL 7 db (on another server)
The problem we are having is that we have changed the password on the SQL database for the login that the reports use to connect to the db and this has caused each report to prompt for login details each time they are refreshed.
We have tried using Set Location and Convert Database Driver as possible solutions but to no avail
Any help would be appreciated as we don't want to have to create these reports from scratch again
Thanks
The problem we are having is that we have changed the password on the SQL database for the login that the reports use to connect to the db and this has caused each report to prompt for login details each time they are refreshed.
We have tried using Set Location and Convert Database Driver as possible solutions but to no avail
Any help would be appreciated as we don't want to have to create these reports from scratch again
Thanks