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

SSC Guru

Points: 323504

March 12, 2015 at 7:28 am

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!