Can Microsoft Reporting Services retrieve data from Oracle?

'm.e.' on Mon, 28 Feb 2005 05:03:00 GMT, sez:

I think you should also be able to use managed providers:
.NET Framework Data Provider for Oracle (http://www.microsoft.com/downloads/details.aspx?FamilyId=4F55D429-17DC-45EA-BFB3-076D1C052524&displaylang=en) or
Oracle Data Provider for .NET (http://www.oracle.com/technology/tech/windows/odpnet/index.html), but have not tested this.

'prasad' on Fri, 01 Apr 2005 03:58:26 GMT, sez:

asdasd

'kanthi' on Fri, 09 Sep 2005 05:42:46 GMT, sez:

how to retrieve data from oracle to vb

'f0vela' on Tue, 28 Mar 2006 12:46:38 GMT, sez:

It's Possible.. right now i'm in the middle of a project that uses an Oracle 9i database and i'm using reporting services to create reports.

It's possible but maybe you'll find some things you can and can't do with them and some Data Providers that don't work all the time.

'Miguel' on Wed, 04 Oct 2006 23:19:54 GMT, sez:

f0vela, can you send me a .rdl demo with the store procedure on oracle?.

Thank

(mgrandez@hotmail.com)

'Juan Manuel Z' on Fri, 09 Mar 2007 16:59:57 GMT, sez:

Hi,

http://www.developer.com/db/article.php/3524781

it works!

(juanmanuelz@gmail.com)

'freeze' on Wed, 31 Oct 2007 05:09:08 GMT, sez:

what about oracle 10g?
the error is missing expression(microsoft OLE DB provider for Oracle)

'Nilesh' on Mon, 28 Apr 2008 18:54:43 GMT, sez:

This is not be a comment but a way i found to ask a quick question

I have been working with Data Processing extension which connects to a Oracle Database. But when I try to grab the SQL created by the Report server I get nothing
just a blank "" commandtext.

But when I connect to SQL Server database I am able to get the generated SQL.

Anybody has any Idea why cant I get the SQL in the DPE when it connects to oracle database?

name


website (optional)


enter the word:
 

comment (HTML not allowed)

All viewpoints welcome. But the right to delete any post for any reason is reserved. Don't make me do it. Aim for constructiveness. Comments may be republished, emailed to your loved ones or printed and used as toilet paper. Also, I get particularly nasty on comment spam. It's not worth even trying to post comment spam here -- your html is escaped, and your links are given a rel='nofollow'. By attempting to post a comment, you understand that if the comment is considered spam, at my absolute discretion, your IP address may be used as the target of a prolonged distributed denial of service attack. Your electricity might suddenly stop working. Your car tyres will go mysteriously flat. You will suffer permanent hairloss. Your dreams will be filled with terrifying monsters. And in any case I reserve the right to record and publish your IP address.

 

TimeSnapper_{Know thyself!}

TimeSnapper is a life analysis system that stores and plays-back your computer use. It makes timesheet recording a breeze, helps you recover lost work and shows you how to sharpen your act.

 

NimbleText is a Powerful FREE Tool

Use it for:

• extracting data from text
• manipulating text
• generating code

It makes you look awesome. Use it right now! Go on! Hurry! Don't walk, run!