VB6 Application using Crystl32.OCX and SQL Server

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

Which version of Crystal do you have? The Crystal32.OCX is included for backwards compatibility.

Regardless, this is probably all you need if the database and table name(s) are the same in both servers.

.Connect = "DSN=rsimmons;UID=loanuser;PWD=lucky7"

I'm using Crystal Version 8.5.

I have used that connect string, but on my client, it indicates it cannot find the SQL Server or it returns error 20534 error in database dll. I'm certain I am using the proper connect string for the client.