May 30, 2017 at 11:04 am
I have SQL Server Management Studio 2016 installed on my PC.
I am tryting to install RedGate SQL Developer Bundle
and it gives me error:
You must have the MDAC components installed in order to install this product
I thought MDAC is automatically installed with SSMS?
It is !!
I just checked SSMS Help.
It says:
Microsoft Data Access Components (MDAC) 6.1.7601.17514
So why RedGate complains?
May 30, 2017 at 3:06 pm
How up to date is your SQL Developer Bundle install?
The SQL Developer Bundle has been retired according to their webpage (http://www.red-gate.com/products/sql-development/sql-developer-bundle/index). I expect that you are using an old version of the installer and that downloading the latest version will help.
What OS are you trying to install it on and what version of the SQL Developer Bundle are you trying to install? I believe they renamed the Developer Bundle installer (when you download it) to "SQLDBABundle.zip". I bet that the installer is out of date.
EDIT - where did you see that SQL 2016 comes with MDAC? I was searching the help and no results were found for MDAC that I could find.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 30, 2017 at 4:54 pm
Technically, it's Windows Data Access Components these days and MDAC/WDAC are part of the operating system now. MDAC used to install with earlier versions of SQL Server but that isn't the case anymore since it's part of the OS. There is no separate installer for WDAC.
The line: Microsoft Data Access Components (MDAC) 6.1.7601.17514 is just listing the version of WDAC from your OS which looks to be Windows 7 (I think). Pretty sure it just reads the registry key as previous versions of SSMS did.
Currently, SQL Server only has the installation components for the SQL Server native client.
Why don't you try contacting RedGate about changing over to SQL Toolbelt? That's basically what replaced the Developer Bundle.
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply