On 27-Apr-18 9:59 AM, Alan Bourke wrote:
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... - etcver-for-sql-server/
.... and unless things have changed, ole-db does not give you a Foxpro type cursor but an ole-db object with properties/methods something like next() previous() etc. - you were compelled to use it for js/vb web queries but I never found it as easy to use as a cursor.