Changing Connection parameters in a Crystal 11 report
Posted on 2006-05-05
I have a crystal 11 report, running from a SQL server stored procedure.
I am using VB6 code to run the report.
I am using CRAXDDRT in the VB6 project.
I am using the ConnectionProperties of the table to set the security, server and initial catalog.
the problem is, if I want to change the name of the SQL server database (for upgrading purposes), the report still attempts to connect to the old database name.
This is causing a problem because if the original database does not exist the program will not run.