I'm using VB.NET 2003 and has a handful of reports created in Crystal Report 8.0. I need to reset the database connection properties as the server/database are different in production and live environment. But I've problem in resetting the database connection properties for the report when it was printed.

The method that I used to reset the dataconnection is set the ConnectionInfo, then loop through each table in the report and apply the LogonInfo information to them. But a database logon window always pop up, and stating the database logon to MS SQL server failed.

Does anyone has any idea how to resolve the above?