Microsoft SQL Server: Determine MDAC Version

Contributed by Rob Rogers  
Tagged: Database  

You can easily determine what version of MDAC your are running on your SQL Server by just typing a few lines into the query window. To do this:

1. Open up the query window in your Enterprise Manager or Management Studio.

2. Copy and paste the following:

USE master
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'

3. Execute the query.

The results will give you the version under the Data column.