Share via

Issues installing latest Microsoft OLE DB Driver for SQL Server ?

techresearch7777777 1,981 Reputation points
2024-01-26T19:19:38.06+00:00

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: User's image

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.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

5 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 27,116 Reputation points
    2024-01-26T20:57:52.8666667+00:00

    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

    Was this answer helpful?

    3 people found this answer helpful.

  2. Mark Bushell 85 Reputation points
    2024-04-09T02:14:49.74+00:00

    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

    Was this answer helpful?

    1 person found this answer helpful.

  3. Erland Sommarskog 134.3K Reputation points MVP Volunteer Moderator
    2024-01-26T22:35:52.11+00:00

    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.

    Was this answer helpful?

    1 person found this answer helpful.

  4. Deleted

    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 comment

    Comments have been turned off. Learn more

  5. Deleted

    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 comment

    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.