Microsoft SQL Server: Determine MDAC Version

Posted October 13, 2006 by Rob Rogers in 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.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.