question

Abdul-5362 avatar image
0 Votes"
Abdul-5362 asked Abdul-5362 commented

SSRS 2016, unable to connect the Oracle DB

Dear ,SSRS is not working with oracle data base, I made the successfully connection by install the oracle client for 32 and 64 bit and configure the path variable but still i cannot run the report.
Every time i test the connection it ok but when im preview the report it say this badly error .
Which is worst error, I have done many work around but it doest not work.
Pls. check this error and provide the solution as soon as possible.



An error has occurred during report processing. (rsProcessingAborted)
An attempt has been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)

sql-server-reporting-servicessql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered Abdul-5362 commented

Sure, the trial is equal to the Enterprise Edition with all features, that will work, but the trial expires after 180 days.
If it's only for testing/developing/learning, then you can use the free Developer Edition, it has also all features.

https://www.microsoft.com/en-us/sql-server/sql-server-2019-comparison

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Prefect Answer..... , Dear

It is working with Developer Edition ,Thanks.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered Abdul-5362 edited

is not supported in this edition of Reporting Services

Orcale as data source for SSRS reports works well, there are no known common issues and it's fully supported: Data Sources Supported by Reporting Services (SSRS)

Regarding the message part above, which Edition are you using?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thank you for the update.

SQL Server Reporting Services 2018

Edition : SQL SERVER EXPRESS
Product Version : 14.0.600.1669
Instance ID : SSRS

  • The Report is geting the data locally when it save on machine(C Or D Drive).

  • Same Report is throwing the Error when it save on Report Server path.

This what i observed and Im struck with Issue from long time pls help to figure and fix it,

SS for reference

89085-image.png





0 Votes 0 ·
image.png (36.0 KiB)
ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @Abdul-5362,

Here is a documentation about Configure Oracle data source for SQL Server Reporting Services (SSDT and Report Server).

https://techcommunity.microsoft.com/t5/sql-server-support/configure-oracle-data-source-for-sql-server-reporting-services/ba-p/319134

You may refer it for more details to see if there are any steps missing.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered Abdul-5362 commented

Edition : SQL SERVER EXPRESS

The free Express Edition of SSRS has several limitation, and access remote data sources is one of it; it's not supported in Express, it can only access the local SQL Server database engine of the same instance.

See SQL Server Reporting Services features supported by editions => Remote and non-SQL data source support => Express: Not supported



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks,

Can i try with trial version , Will this work?

0 Votes 0 ·