Hi,
I'm fedup with this problem.
I have developed a package using VB 6.0, Access, Crystal 8.5 (Crystal Active X Control i.e Crystl 32.OCX). I create reports through DSN.
Application and reports are running perfectly without Database Password.
But when i put Password to Access database and same Password to DSN. Reports are not running and display an error message 20599 Cannot open SQL Server. without Password database is not safe.
Kindly help me to solve this problem.

Code:
Cry.Reportfilename="C:\Report1.rpt"
Cry.connect=Conn.connect
Cry.Action=1

Regards,
Sohrab
Email: sohrab.ahmad@alfozan.com
sohrab_as@rediffmail.com