Post reply

SSRS BIDS Error when executing oracle query (This command is not supported by this provider)

  • October 31, 2012 at 6:00 pm

    #283853

    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

  • October 31, 2012 at 9:16 pm

    #1554833

    tinnusqlserver (10/31/2012)

    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

    Can you run this query successfully from somewhere (meaning with another tool) else? It sounds like your connection provider (OLEDB, ODBC or whatever) doesn't support whatever you're doing. It doesn't sound like the problem is SSRS.

    Rob

  • October 31, 2012 at 9:24 pm

    #1554834

    Hi, Thanks for your response.

    I had executed this query in oracle toad on the same machine and it worked fine.

  • November 1, 2012 at 2:46 pm

    #1555200

    I'm not familiar with Toad, but are you sure it's using the same driver?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply