SQLTeam.com | Weblogs | Forums

Linked Server


#1

Hi,

how can I find out which driver a linked server uses. We have 2 Oracle OLEDB drivers installed (11 and 12), and we would like to know which driver is being used. Is this information in the registry - or in a config file?

Regards
Nicole
:slight_smile:


#2

Does this tell you anything useful (in the [SRV_PROVIDERNAME] column, or perhaps one of the other columns such as [SRV_PROVIDERSTRING]

EXEC sp_linkedservers

Maybe there is some additional information is

SELECT *
FROM sys.servers