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.
| 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 thisraj |
|
|
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. |
 |
|
|
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 |
|
|
|
|
|
|
SSRS BIDS Error when executing oracle query (This