Connecting to MS SQL Crystal Report 9 from VB6
Hi.
I am calling my Crystal Report file from my VB6 code. Report is using data from MS SQL 2000 database. My code look like this:
Dim connProp As CRAXDRT.ConnectionProperties
Set m_Application = New CRAXDRT.Application
Set m_Report = New CRAXDRT.Report
Set m_Report = m_Application.OpenReport(App.Path & "\Report.rpt")
Set connProp = m_Report.Database.Tables.item(1).ConnectionPropert ies
connProp("DSN") = "ServerName"
connProp("Database") = "DatabaseName"
connProp("User ID") = "my_login"
connProp("Password") = "my_password"
I get an error message:
"Automation error
The object invoked has disconnected from its clients."
Thank you for your help
|