I am trying to create an Ad Hoc report project using SSRS2005. We are using Oracle 10G and I have Visual Studio2005.
I have the Oracle client installed and I am an administrator.
I create a new "Report Model Project " and attempt to create a new data source, but with "Create a data source based on an existing or new connection " selected, I click on "new " where I should be
able to specify the database, but the Provider shows "SqlClient Data Provider " and is grayed out so I can't change it.
How do I tell it I want to point to Oracle data? I have no trouble normally doing this with an SSRS report but this is the first time I have tried an Ad Hoc report so I don't know what the problem is.
View Complete Post