Interesting. Thanks for the update, Alan.
I now have the great joy of a true SQL DBA at my company who really knows his MSSQL stuff. I'll be curious to see what he has to say.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Alan Bourke Sent: Friday, April 27, 2018 4:59 AM To: profoxtech@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources?
On Thu, 26 Apr 2018, at 6:26 PM, Richard Kaye wrote:
I thought OLEDB was a proprietary Microsoft technology and they stopped pushing that a while ago?
It's a Microsoft wrapper for ODBC designed to simplify it and additionally support things that aren't relational databases, like spreadsheets.
They did deprecate it and recommended ODBC for talking to SQL Server going forward, however as of 30th of March this year they have reversed that decision and released a new SQL Server OLEDB driver.
https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microso...