none
Connection string for new OLE DB Driver 18 for SQL Server RRS feed

  • Question

  • I have SQL Server 2019 CTP 3.0. I need to connect to it from Excel VBA through ADODB library with new OLE DB 18 driver. How connection should look like to use this new driver? I have found something like this:

    Provider=MSOLEDBSQL;DataTypeCompatibility=80

    Will this pickup new driver? Is DataTypeCompatibility necessary?


    There is no knowledge that is not power.

    Thursday, June 27, 2019 6:52 AM

Answers

  • I have found the answer:

    To enable the usage of OLE DB Driver for SQL Server, ADO applications will need to implement the following keywords in their connection strings:

    • Provider=MSOLEDBSQL
    • DataTypeCompatibility=80

    Also more detailed information here.


    There is no knowledge that is not power.


    • Marked as answer by JohnyL Thursday, June 27, 2019 7:24 AM
    • Edited by JohnyL Thursday, June 27, 2019 7:36 AM Added link
    Thursday, June 27, 2019 7:24 AM