RDC DSN-Less Connection to MS SQL Server

[agersh]

Visual Basic 6 and Crystal Reports 9.

Using the Report Designer Component Database Object I am trying to dynamically connect to a MS SQL Server 2000 database. From the technical reference documentation I was able to find the required Connection Properties except for the property that is needed to tell RDC what type of database I am connecting to.

What connection property am I missing?


CrReport.Database.Tables(1).ConnectionProperties.Item(???????) = DBConnString.Driver
CrReport.Database.Tables(1).ConnectionProperties.Item("server&quot = DBConnString.Server
CrReport.Database.Tables(1).ConnectionProperties.Item("database&quot = DBConnString.Database
CrReport.Database.Tables(1).ConnectionProperties.Item("password&quot = DBConnString.Password
CrReport.Database.Tables(1).ConnectionProperties.Item("user ID&quot = DBConnString.UserId

 

[vidru]

Everything you need to know about ConnectionProperties:

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

Looks like you're missing "Provider".

-dave