I have a VB6 app that uses the Crystl32.OCX. The report is designed using SQL Server A. In runtime, I need to change that to SQL Server B. I have tried this using the Connect property as:

CrystalRpt.Connect = "uid=loanuser;pwd=lucky7;driver={SQL Server};server=rsimmons;database=LOANS;dsn="

This gives a dll error on the client.

Does anyone have any help?

Thanks