LogonInfo Property in Crystal 8.0

[guitarwit]

Hi, I can't seem to figure out how to use 2 different ODBC data sources in crystal 8.0 with SQL Server. I have different login id/passwords for the two tables. I need to be able to log into both databases using these different logins. I hope that makes sense. Any help would be appreciated!

Thanks.

 

[IdoMillet]

Interactively, Crystal would prompt you.

Programmatically, you need to loop through and deal with the logon info of each Table.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[guitarwit]

I'm using VB6 when trying to program this. Below is what I attempted to do.

CrystalReport1.LogonInfo(0) = "PWD=password"
CrystalReport1.LogonInfo(1) = "PWD=password"

I read that crystal stores the login id etc with the report, so I just needed to supply the password. I was using the connect property for one database and it worked fine...but now I needed to connect to the two different databases.

Thanks.

 

[Harshu]

check the FAQs for crystal reports i have posted the sample there hope it will help u.

Harshu.