Provider selection gray, unable to change it in Data Source Creation
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.
October 21st, 2010 5:38pm
Hi Terry, What's your permission to logon this machine? Generally, it is available and can be changed to Oracle Client Data Provider. So, please chcek your permission. thanks, Jerry
October 22nd, 2010 1:22pm