In benchmark scenarios (e.g., bulk inserts, large rowset retrieval), MSOLEDBSQL performs comparably to the latest ODBC Driver for SQL Server. However, OLE DB’s rowset objects ( IRowset ) can provide lower memory overhead in certain COM-based applications compared to ODBC’s handle-based model.
Provider=MSOLEDBSQL;Server=myServer;Database=myDB;Trusted_Connection=yes; Use Encryption for Data=true;Trust Server Certificate=false; microsoft ole db driver