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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:12 AM
Points: 72, Visits: 394
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:54 AM
Points: 2,866, Visits: 1,707
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