Unable to Open Database error (connecting to SQL Server) 1

[Trusts]

Hi all,

I have been trying to pass a string to the .Connect property of the Crystal OCX. The sytax I have been using is:

.Connect = "DSN=(local);UID=;PWD=;DSQ=HB_Tables"

This does not work. HB_Tables is the database name. The SQL Server is local on my dev machine. I cannot connect, I'v tried all variations on this connect string.

Any ideas!??

Thanks!

 

[synapsevampire]

Posting your version of Crystal is a basic requirement.

Th4e OCX is no longer supported, ill advised, and the RDC is a much better way to implement, however here's the sample:

http://support.businessobjects.com/communityCS/TechnicalPapers/apps_ocx.pdf.asp

-k

 

[Trusts]

Thanks, I'll check out the documentation.