Crystal refuses to accept credentials
I have a series of reports that are running fine in VB.Net. They access Sql Server without issue. However, I made a small change to a report on my development machine and put the RPT file on the server for use. The EndUsers are reporting that they are receiving a prompt for logon information.
The code passes in the logon information and the executable was not changed. The only change was to drop 2 more fields from the Sql Server database on the report. Test it on the development machine. Copy the report to the Server.
The code loops through the report and changes the logon info for each table. The database name and schema are the same in the test environment and production environment. What is really kind of strange is that even if I put in the correct credentials, it still will not run the report. But if I go to the client, open the Report and save it, then it works just fine. Once again, no Program code change, but an open and close of the Crystal report seems to make the world alright again.
I am trying to prevent having to make a trip to the Client for such a minor change. Any idea what I might want to check? Code is attached.