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 per Customer IP Address, it also work fine with ADO Data Control in Form without any error data saved in customer SQL server.

Recently : I Solve this problem by install crystal report at Customer Place and Open the Report at customer Site then Set Location manually, it will solve my problem time being but is their any way to set this properties Programmatically ?