Datasource won't switch in VS 2008 CR2008

I have a report with 1 command object that originally connected to an ODBC datasource. I would now like to connect using an ADO dataset. Here is my code.

myReportsDocument.Load("c:\goldfish.rpt")
...set up dataset.ds
myReportsDocument.SetDataSource(ds)
myReportsDocument.ExportToDisk(ExportFormatType.PortableDocFormat, "C:\goldfish.pdf")

I've also used myReportsDocument.Database.Tables(0).SetDataSource(ds) at line 3 to no avail. No matter what I do it seems to want to point to the ODBC connection. How can I point it to the dataset instead?

The ado dataset is pointing to an oracle database using System.Data.OracleClient.

Thanks in advance,

J

Edited by: Jason Cameron on Mar 10, 2009 3:36 AM

Edited by: Jason Cameron on Mar 10, 2009 4:41 AM (added data location of dataset)