Hi,

my vb coding are as below:

Code:
CrystalReport1.WindowTitle = "Testing Report"
CrystalReport1.ReportTitle = "Testing Report"
CrystalReport1.ReportFileName = App.Path & "\testing.rpt"

CrystalReport1.Connect "DSN = testing; UID = sa; PWD = sa"
CrystalReport1.Destination = crptToWindow
CrystalReport1.WindowState = crptMaximized
CrystalReport1.DiscardSavedData = True
CrystalReport1.Action = 1
I'm running my vb source code at Windows Vista, VB6 SP6, CR 8, DSN set to "testing" & tested successfully ...

After the code line "CrystalReport1.Action = 1", it shows the CR for a while, but no data, then it jump out and give me a "Cannot Open Sql Server" msgbox

any idea on how to solve this???