Cannot connect to SQL Database using TestComplete

I had to change my connection strings recently when we updated our server. (Provider='SQLNCLI11' quit working)  Provider=MSOLEDBSQL works for me.  Here I am connecting and doing an async call to a stored procedure.  The connections strings and ADO stuff will be what you want.
     

// After all customers are created, run the CustomerSyncToSQLFilePro procedure
  let sProcSync = ADO.CreateADOStoredProc();
  sProcSync.ConnectionString = "Provider=MSOLEDBSQL;Data Source=ProdSQL;"+"Initial Catalog=TestingTeam;Integrated Security=SSPI";
  sProcSync.CommandTimeout = 120;

// Execute CustomerSyncToSQLFilePro stored procedure
  const syncResult = await execCustomerSyncToSQLFileProAsync(sProcSync);
  Log.Message(syncResult);

// Close the sync stored procedure connection
  sProcSync.Close();