Currently I change my datasource connections by looping through all the report.Database.Tables and applying a new ConnectionInfo object. This works great for reports that JUST use oracle tables.

 

But NOT for reports that call a procedure in a package. Those only work if I save the rpt with the correct datasource location which obvisouly is unacceptable. It sems I'm unable to change the connection info at runtime. I get "Failed to retrieve data from the database. 6550". Or something else is getting set/changed when I save the rpt.

 

After peeking into my report object after I load it, I noticed my report.DataSourceConnections still contains ONE entry for my designtime datasource location even though I called report.DataSourceConnections.Clear(); Interestingly, the report.Database.Tables contains an entry for the procedure name, so I figured I was changing it. After I've looped, that one entry in the report.DataSourceConnections does contain the correct connection info.

 

But the report still won't run....

 

Any ideas?