Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Set the Database connection in report at runtime in VB 6.0

Hi,

I have a report created in CR XI that connects to the oracle server. The report works fine if I have same Service name in the tnsnames.ora file which I had used while creating the report.

But I dont want that. I want that I pass a recordset directly to the report and it uses the connection that was used to create the recordset. but it doesnt do that and I get "Failed to open the connection" error

This is the way I have the code

dim lrpt as CRAXDRT.Report

AdoRecordset.open (ReportQueryString)

lrpt.Database.SetDataSource (AdoRecordSet)

Can someone tell how can I make this working??

Thanks,

Reena

Former Member
Not what you were looking for? View more on this topic or Ask a question