This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Hello, a machine has what looks like an old OLE driver as follows:
Microsoft OLE DB Driver for SQL Server = Version 18.5.0.0
I downloaded and tried to install the latest at:
Download Microsoft OLE DB Driver 19 for SQL Server (x64)
I get the following error:
I go to that link mentioned in error popup message https://aka.ms/vs/17/release/vc_redist.x64.exe download and ran what seems successfully installed Microsoft Visual C++ Redistributable latest supported downloads. After rebooting I tried again re-running latest Microsoft OLE DB Driver 19 file that I initially just downloaded and still get the same exact error popup message. What else needs to be done? Thanks in advance.
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @techresearch7777777, If you are not working with MS SQL Server 2022, I would suggest to download and install Microsoft OLE DB Driver v.18.6.7: https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16#1867
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 85%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
This is helpful, Microsoft OLE DB Driver v.19 doesn't work with HeidiSQL
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 23%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Hi,
I've had this exact same issue. Not sure if you've resolved it, but with the Visual C++ for 2022 Redistributable it requires, it actually needs both the x64 and x86 versions, and I made sure to have them both installed with the latest versions so they're both identical. The MS OLE DB SQL 19 installer worked after the fact.
Hope this helps.
MB
Did you install the x64 version of the redistributable? Beware that this provider has a different name, MSOLEDBSQL19, than the current driver that you have, which is MSOLEDBSQL without a numbre. So connection stinrgs would need to be changed to use this new provider.
Thanks bunch Erland for your reply as well.
Went to following Microsoft website: https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170#visual-studio-2015-2017-2019-and-2022
Installed within link X64 version link as follows (this computer is Windows 10 64-bit operating system, x64-based processor)
Afterwards currently these are what are showing up existing side by side:
This computer has SQL Server Management Studio which connects to other SQL Server instances. Goal is to address any out dated unsupported portions to meet Security team's scan report but still be able to continue to use SQL Server Management Studio and any other components needed to do as a DBA. Anything else can be done or ok to uninstall anything here or something else? Regards.
It's not a good idea to uninstall something that actually is in use. What you use on your system, I don't know. But you get some drivers with SSMS, although SSMS don't use them for querying. But I guess it is for the Import and Export wizard. That wizard exposes SQL Server Native Client 11, I believe. The wizard is not going to die if you uninstall SQLNCLI11, but you will not be able to use that part of the wizard.
Thanks again Erland, much appreciated.
Just some additional info if you have any further suggestions these are the "Microsoft OLE DB Driver *" that's installed also currently existing side by side:
Regards.
Those are two different OLE DB drivers. Or well, they are different incarnations of the same driver. But the important thin is that an application typically specifies in the connection string which driver to use. Few applications are dynamic in this regard.
So if you have applications that use Provider=MSOLEDBSQL in the connection string, and you uninstall driver 18, they are not magically not going to start using Provider=MSOLEDBSQL19, but this needs to be changed somewhere. (Source code, config file etc.)
And that is a good thing in this particular case, as there are breaking changes between MSOLEDBSQL and MSOLEDBSQL19 with regards to encryption.
For reference, here is a list of OLE DB providers/drivers for SQL Server, and which versions of SQL Server they were released with.
The later versions are release out of band with SQL Server releases.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
1 deleted commentComments have been turned off. Learn more
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
1 deleted commentComments have been turned off. Learn more
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 40%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)