Changing the server name & database name of a crystal report through front end?

Development Environment :

OS : Window 2000
Development Tool : VB 6.0
Backend : SQL Server 2000
Reporting Tool : Crystal Report Version 8.5
Using Active X Control Version

I developed application in VB 6.0 with Backend SQL Server 2000,
Report is Develop in Crystal Report 8.5 with approach putting Active X Control on Main MDI Form to generate report through assign properties of Crystal Report, Connection use OLEDB SQL Server

Problem : I develop any of the report at my office work fine, but when I shipped at customer place it will generate error SQL Server not found because there is different Sever Name at customer Site so how do I set the data source (OLEDB Connection, Tables Location) Programmatically

I do set properties of crystal report as below

MDIForm.oCrystalReport.ReportFileName = ListReportFileName.rpt
MDIForm.oCrystalReport.Connect = ConnectString
MDIForm.oCrystalReport.Action = 1

Note : here connect string I dynamically changed through global var as p

Just modify the connectstring and reset the control to the new string, then open it up. Same with the report file. You can load reports into the control just by changing the report parameter. In the worst case scenario you can always create a new control, configure and replace the old one.