VB6 Application using Crystl32.OCX and SQL Server [Archive]

Click to See Complete Forum and Search --> : VB6 Application using Crystl32.OCX and SQL Server

randysimmons

Mar 13th, 2006, 12:49 PM

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

brucevde

Mar 13th, 2006, 02:15 PM

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"

randysimmons

Mar 14th, 2006, 05:38 AM

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.