This content has been marked as final. Show 3 replies
Hey, I have installed the odac on VS 2010 and if I go to Tools->Data Connection the odp.net driver is the default driver. However, if I do a reporting project, and do new data source, all I can see is the MS provided .net driver. Have you found a way to get the odp.net drivers to show up for New Data Source in a Reporting Services Project?
thanks for your time,
I believe that to use a data provider through the Report Designer, it needs to implement a data processing extension (DPE). ODP.NET does not implement a DPE, which is why it doesn't show up in your data source list. You can still use ODP.NET in Reporting Services, just not with functionality that requires a DPE.