• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to Register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Install and configure Oracle ODBC drivers

Collapse

Unconfigured Ad Widget

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Install and configure Oracle ODBC drivers

    WordPress Hosting on SSD Servers
    Hello everyone,,
    I'm having the dangedest time finding and installing the Oracle ODBC drivers. I'm trying to write a report on data that lives in our only Oracle DB. I have a working SQL statement, but I just can't figure out how to get the ODBC drivers setup.

    I have the instant client downloaded and installed, but it said I need to run netca to configure the listener. I couldn't find that on Oracle's website, though; and the "client" install didn't seem to do what I needed. What am I missing?

    Also, if there's an easier way, I'm all ears. I just need a way to connect Microsoft's SSRS with Oracle.

    Thanks!
    Last edited by admin; 11-13-2019, 09:39 AM.

  • #2
    ASP.Net Hosting starts @ $3.18/Mo.
    I can help you with connecting Microsoft SSRS with Oracle.
    First, please check the edition of your SQL server 2016, if you used express, Oracle data source is not supported in SSRS because express edition only works with local data which Oracle is not.

    To retrieve report data from an Oracle database, your administrator must install Oracle client tools and .NET Data Provider for Oracle. This data provider uses the Oracle Call Interface (OCI) from Oracle 8i Release 3 as provided by Oracle Client software. The client application version must be 8.1.7 or later. This data provider must be installed in the server machine (and client machine for SSDT-BI). Until it is installed in the server it will not be loaded/displayed by SSRS.

    Comment

    Working...
    X

    Sign up for a News Letter Click here to sign up