Cannot Open SQL Server Error No :20599

[nateshk]

Hi,

Iam using Crystal Report Active X Control for displaying my report. Within VB iam trying to connect to a new database.

But it is unable to do so giving error "Cannot Open SQL Server Error No :20599"

Hope somebody can help me.

Thanx
Natesh

Code :

With crxReport
.ReportFileName = App.Path & "\X.rpt"
.LogOnServer "p2ssql.dll", strServerName, strDatabase, strUID, strPwd

.Action = 1
End With

 

[synapsevampire]

Here's the sample apps for VB, you don't have much code posted here...:

http://support.crystaldecisions.com/fix/samplescr.asp#Sample applications for application developers

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com