Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Which OLEDB drivers are installed? Expand / Collapse
Author
Message
Posted Thursday, October 11, 2012 4:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 12, 2015 9:05 AM
Points: 102, Visits: 510
does anyone have any (non-developer) advice regarding how to determine which OLEDB drivers are installed on any given Windows machine.

ODBC drivers are easy (ODBCAD32), but OLEDB has no central Administration Point (that I'm aware of).

I know there are a few VB scripts available which hunt through the Registry but is there a 'safer' way without exposing the registry to third-party scripts to determine which drivers are installed?
Post #1371334
Posted Friday, October 26, 2012 2:25 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:34 AM
Points: 3,010, Visits: 2,080
You could try executing sys.sp_enum_oledb_providers


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1377433
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse