Connect to SQL-server...?

[kenjoswe]

Hi all,

How do I connect Crystal Report to a SQL-server from VisualBasic in runtime?
This is how I connect VB to SQL-server:
conn.Open "Provider=sqloledb;" & _
"Data Source=ServerName;" & _
"Initial Catalog=DatabaseName;" & _
"User Id=UserId;" & _
"Password=PW;"

What is the syntax in Crystal Report? Report1.Connect?

/Kent J.

 

[Adam95]

Try this:

Dim Application As CRAXDRT.Application
Dim Report As CRAXDRT.Report
Set Application = CreateObject("CrystalRuntime.Application&quot
Set Report = Application.OpenReport(ReportFile)
Report.Database.Tables(1).SetLogOnInfo "in01-sql03-nt", "QualityDevl", "[username]", "[password]"


Maybe this will help to get ya started.

Adam

 

[kenjoswe]

OK! Thanks.

With:
Report.Database.Tables(1).SetLogOnInfo "in01-sql03-nt", "QualityDevl", "[username]", "[password]"

Do you mean?:
Report.Database.Tables(1).SetLogOnInfo "ServerName", "DatabaseName", "[username]", "[password]"

/Kent J.

 

[Adam95]

That is correct