How can I tell which version of MDAC I'm running?
The simplest way is to use the version property of the ADODB.Connection object, such as:
Another way is to go to Start, Run... and type regedit, then look at the following key:
You can read this registry key from T-SQL, provided you are connected as a user with sufficient rights:
Yet another way is to find msado15.dll (in %SYSTEM32%\DLLCache\), right-click it and hit properties, and look on the version tab. This should produce the exact same result as the registry scan above.
You can also use the component checker, available from download.microsoft.com. Information about using this tool is available in KB article KB #307255.
For some other ideas, see KB #301202.
For a history of MDAC releases, see KB #231943.
To obtain the most recent version of MDAC, see MDAC Download Page.
Related ArticlesCan I fix this mm/dd/yyyy <-> dd/mm/yyyy confusion once and for all?
Could I get some help with JOINs?
How do I access MIN, MAX, SUM, COUNT values from SQL statements?
How do I change column order in a table structure?
How do I change the order of columns in a table?
How do I concatenate strings from a column into a single row?
How do I convert columns of values into a single list?
How do I determine if a database exists?
How do I document / compare my SQL Server database(s)?
How do I get the IDENTITY / AUTONUMBER value for the row I inserted?
How do I solve 'ADO Could Not Find The Specified Provider'?
Should I use BETWEEN in my database queries?
Why can't I use the * wildcard in a database search?
Why do I get 'Syntax Error in INSERT INTO Statement' with Access?
Why do I get weird results when using both AND and OR in a query?
Why do some SQL strings have an 'N' prefix?
Why does AbsolutePosition return as -1?
Why doesn't SQL Server allow me to separate DATE and TIME?
Why is Query Analyzer only returning 255 characters?
Why should I avoid NULLs in my database?
How do I deal with an apostrophe (') in a SQL statement?