I am creating a SSRS report which directly gets the data from oracle.
When i run this query in the "query designer" then i am getting an error saying
"This Command is not supported by this provider".
I had tried using 'Oracle' and 'OLEDB' connection types but they didn't worked.
I am using Microsoft Visual Studio 2008.
Please advise me on this
Are you running a SQL Command? what is the SQL? Does the SQL run directly against Oracle (i.e. in TOAD or SQLPLUS)