Changing data source dynamically in runtime

[awhitsel]

I have an application written in VB 5 using Crystal Reports 9 for a couple of reports.

In the code I am using the Report.Database.LogOnServer to set the DSN and database that the CR9 report is looking off of.

We would like to be able to change the DSN and database between a production and test environment in runtime. We tried using an If.Then.Else statement to do the change but it fails unless we use the production environment.

Please advise.

Thanks.

 

[vidru]

I've got a faq on this (faq768-5374) - How do I change Database location at runtime (VB6 - RDC)?

-dave