Hi Everybody

I am using SQL Server2000, VB6 and Crystal Report6.
I use DSN connection for preview the report of crystral
in vb6 by using this code........

Private Sub CmdPreview_Click()
Dim strRepName As String
Dim SqlString As String
strRepName = "division.rpt"
SqlString = "select * from division"
Me.CrystalReport1.ReportFileName = strRepName
Me.CrystalReport1.SQLQuery = SqlString
Me.CrystalReport1.Destination = crptToWindow
Me.CrystalReport1.Connect = "dsn=Acct"
Me.CrystalReport1.Action = 1
End Sub

But SQL Server in windows authentication... If i change to
server authentication this report not show if show the
error "Can not open SQL Server"

For security of database i have to change from windows
authencation to server authencation...

Pls guide how the call the report using DSN
in server authentication

Thanks

ASM