Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 SSRS BIDS Error when executing oracle query (This

Author  Topic 

raj vardhan43
Starting Member

20 Posts

Posted - 2012-10-31 : 20:01:30
Hi All,

I am creating a SSRS report which directly gets the data from oracle.

I am running an oracle query in bids.

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

raj

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-11-01 : 08:17:03
Instead of using the query designer, you might try developing the query in Oracle and simply pasting it to the Query window in BIDS.
Go to Top of Page

raj vardhan43
Starting Member

20 Posts

Posted - 2012-11-12 : 14:15:06
Thanks!! That helped
quote:
Originally posted by sunitabeck

Instead of using the query designer, you might try developing the query in Oracle and simply pasting it to the Query window in BIDS.



raj
Go to Top of Page
   

- Advertisement -