Skip to Content
Former Member
Mar 10, 2009 at 08:36 AM

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.

...set up dataset.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,


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)