How to find which oracle client is being used by SSRS Reports

Question

Post reply

How to find which oracle client is being used by SSRS Reports

saxena200

Ten Centuries

Points: 1156
More actions
March 12, 2015 at 6:24 am

#316220

Hi all,
we have multiple oracle clients installed in the reporting server; is there any way to find out which oracle client's library is being used by the reporting server;
Platform - windows 2012 r2
sql server 2014
Oracle 11g

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

this gives you the name of the report + name of the shared data source;

if your reports have embedded data sources, i think you have to open each report.

from there, would you know offhand which resource is using which library?

select

Catalog.name,

cat1.Name datasource

from

Catalog

join DataSource

on Catalog.ItemID = DataSource.ItemID

join Catalog cat1

on DataSource.Link = cat1.ItemID

where

Catalog.Type = 2

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

saxena200 Ten Centuries Points: 1156 More actions · Answer 2

Hi Lowell,

thanks for your response, but I do know the share DS and it is configured using oracle db provider; I wanted to know that which oracle client's library the driver is using

Lowell SSC Guru Points: 323504 More actions · Answer 3

i think you just have to open each datasource in the web client and review it to see if it is using ORAOLEDB.Oracle, or ORAOLEDB.Oracle.1 right? how many unique shared data sources do you have?

on my server, i only have six, so it wouldn't take too long to manually open each one to review.

i just tried to convert the originalConnectionString in ReportServe.dbo.DataSource to a string to charindex it, but it doesn't convert cleanly;

select

convert(varchar(max),convert(varbinary(max),OriginalConnectionString) ) As cn, *

from DataSource

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!