How to Connect Oracle Database in SSRS 2019

Rajesh Chittineni 141 Reputation points

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

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 "


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

    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:

    Below is the download link for you.

    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

    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

    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

    Hi ,

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


    TNS Ora flle placed in the below location

    Below is the screenshot


    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

    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