How to Connect Oracle Database in SSRS 2019

Rajesh Chittineni 141 Reputation points
2020-11-26T13:06:48.457+00:00

Hi Team,

We have requirement to connect Oracle database in SSRS 2019 through visual studio. We have followed the process mentioned in the below link. But not able to get connected

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

Not able to getting an option to give the user name and passowrd. For one of my colleague this option is enabled but getting an error like "ora 12541 tns no listener "

42996-image.png

Could you please help on this

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,797 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 32,586 Reputation points
    2020-11-27T06:15:52.1+00:00

    Hi @rajeeec-5608m,

    The error message shows ‘The 'OraOLEDB.Oracle.1' provider is not registered on the local machine’.

    I did some research online, please make sure you have already installed both 64-bit driver and 2-bit driver ODAC.

    Here is an article. for your reference:

    https://www.ibm.com/support/pages/oraoledboracle1-provider-not-registered-local-machine-when-testing-database-connection

    Below is the download link for you.

    https://www.oracle.com/database/technologies/dotnet-odacmsi-vs2017-downloads.html

    https://www.oracle.com/database/technologies/odac-downloads.html
    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.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments No comments

4 additional answers

Sort by: Most helpful
  1. Olaf Helper 40,741 Reputation points
    2020-11-26T14:00:52.607+00:00

    You have to enter first the server name before you can edit the credentials.

    Regarding the error, is TNSOraName file setup correctly? Can you TNSPing the Oracle server / connect to using Oracle tool like SqlPlus?

    1 person found this answer helpful.
    0 comments No comments

  2. Olaf Helper 40,741 Reputation points
    2020-11-27T07:30:54.447+00:00

    The OraOLEDB.Oracle.1 provider is not registered

    SSDT is a 32 bit application and requires 32 bit ODAC; you have to install that as well.

    1 person found this answer helpful.
    0 comments No comments

  3. Rajesh Chittineni 141 Reputation points
    2020-11-26T15:29:36.767+00:00

    Hi ,

    Even after giving the server name also not able edit the credentials

    43007-image.png

    TNS Ora flle placed in the below location
    C:\app\client\username\product\12.2.0\client_1\Network\Admin

    Below is the screenshot

    43049-image.png

    and the dll also installed using the below one. But still getting same error.

    regsvr32 C:\app\client\username\product\12.2.0\client_1\bin\OraOLEDB12.dll

    Could you please help on this.

    0 comments No comments

  4. Rajesh Chittineni 141 Reputation points
    2020-11-27T09:47:55.893+00:00

    Hi Zoe and OlafHelper,

    Thanks for providing the details.

    I installed wrong 32 bit version . Now i have installed proper 32 bit version ODAC and updated the tnsnames.ora in both the locations (32 bit and 64 bit).

    Thanks for your great help.

    0 comments No comments