Visual Basic 6 Crystal Reports 10 MS SQL Server 2005

I have several external rpt files
Some of them use only tables, others use one Stored Procedure and tables and others use only one Stored Procedure

All of the reports use data type = OLE DB (ADO)

I need to change the Server Name at running time using VB6 code because all the report files were designed using a development server and we need to change to production server

When the rpt use only Tables I can change the Server Name using ConnectionProperties

My problem is when it is a Stored Procedure

Maybe one of You know the way to do it... please help me...
Thanks
JG