Latest OLEDB and ODBC drivers RRS feed

  • Question

  • User-443210350 posted

    I understand that Microsoft decided back in 2011 to deprecate OLE DB and that no new drivers or maintenance would occur beyond SQL Native Client V11. In future you should use ODBC based drivers - http://weblogs.sqlteam.com/dang/archive/2011/09/04/rip-ole-db.aspx

    The latest ODBC driver being 'Microsoft ODBC Driver 13 for SQL Server' release on 25th July 2016 - https://www.microsoft.com/en-us/download/details.aspx?id=50420

    ODBC drivers from Native Client V9,10,11 and the Microsoft ODBC Driver SQL Server V11 and 13 all work in Classic ASP code interacting with SQL server (I am using SQL 2012) except for one problem - nText and Nvarchar(max).

    They just return blank - I have seen solutions saying you should read into a local variable first rather than addressing the recordset directly e.g. varStr=rs("LargeText"), but that does not work for me. And there is other mentions of using get chunk etc.

    But I am quite happily using Native Client V9 (Provider=SQLNCLI) which works perfectly with these data types.

    So, my questions are:

    Is there anyway to get ODBC drivers working with nText/Nvarchar(max) datatypes?

    Is there any benefit to using ODBC over OLEDB?

    Do I have to upgade to ODBC at some stage in order to connect to SQL server in future i.e. SQL 2014/2016?

    In other words, can I just carry on using OLEDB going forward?

    Wednesday, July 27, 2016 9:10 AM


All replies