Microsoft SQL Server: Determine MDAC Version

Posted October 13, 2006 by Rob Rogers in Database

Last Updated on

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.

Leave a Reply