Upgrading to 'ODBC Driver 17 for SQL Server' from 'SQL Server Native Client 11' for ADO.

Question

1)Im using ADO(msado15.tlb) in C++ to connect to Local/Remote SQL Server. Now changing ODBC driver from 'SQL Server Native Client 11' to 'ODBC Driver 17 for SQL Server'. Is there any thing to be taken care (Multisubnet,XML datatypes,TLS,AD User)? Should i specify "Provider=MSOLEDBSQL;" in the connection string to get any advantage?

2)Any advantage over ADO(_ConnectionPtr) for MFC CDataBase when using only ODBC-DSN?

Answer 1

Hi @gopsvr ,

I can only reply the question about SQL server.

> Should i specify "Provider=MSOLEDBSQL;" in the connection string to get any advantage?

Provider=MSOLEDBSQL means using Microsoft OLE DB Driver for SQL Server connection strings.

Driver={ODBC Driver 17 for SQL Server} means using Microsoft ODBC Driver 17 for SQL Server connection strings.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.

Answer 2

Additional see https://www.connectionstrings.com/microsoft-odbc-driver-17-for-sql-server/

Answer 3

Thank you But i was looking for what to use. Found ODBC 17 has some issues with xml,varchar(max) fields where the MSOLEDBSQL returns the values properly. CDatabase is also giving issues for xml columns. With Convert to varchar can solve this issues.