Unable to set a new report connection to Oracle

Hi,

Crystal Reports v. 11.5.10.1263

VS Studio 2005

Oracle client 10.2, no connectivity issues

I am changing the connection at runtime to connect to another instance of Oracle database.

the report is of type ReportDocument.

report.DataSourceConnections[0].SetConnection("name from tnsnames.ora", null, "username", "password");

It does not seem to work. It does not set the new connection.

Any input appreciated. Thanks