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.
