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 <[email protected]> On Behalf Of Alan Bourke Sent: Friday, April 27, 2018 4:59 AM To: [email protected] 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-microsoft-ole-db-driver-for-sql-server/ -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/dm5pr10mb12442ad2f2188b3be48e3ac8d2...@dm5pr10mb1244.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

