Set the Database connection in report at runtime in VB 6.0

[Former Member]

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_member11696]

Please re-post if this is still an issue to the Legacy Application Development SDKs Forum or purchase a case and have a dedicated support engineer work with you directly

[Former Member]

Hi Reena,

If you have code related issue.

Post your question in Development - Forum

Business Objects SDK Application Development

Link is here :

[https://www.sdn.sap.com/irj/sdn/businessobjects-sdk-forum]

Regards,

Shweta

[Former Member]

Why do people always post dead links?