Connectors will not work after upgrading to 7.5 or 7.6

Connectors will not work after upgrading to 7.5 or 7.6

After upgrading from 6.5 or 7.0 to 7.5 or 7.6, the Spotfire connectors stop working.
 
The details of the error will be:
 
An exception was thrown by the data connection.
Exception text:
System.MissingMethodException: Method not found: 'Spotfire.Dxp.Data.Access.Query.SqlQuery Spotfire.Dxp.Data.Access.Query.Visitors.UnnestSqlQueryTransformation.Execute(Spotfire.Dxp.Data.Access.Query.SqlQuery)'.
   at Spotfire.Dxp.Data.Adapters.SqlServer.SqlServerAdapterConnection.Transform(SqlQuery query)
   at Spotfire.Dxp.Data.Adapters.SqlServer.SqlServerAdapterConnection.ExecuteQueryCore(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)
   at Spotfire.Dxp.Data.Access.Adapters.DataAdapterConnection.ExecuteQuery(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)
   at Spotfire.Dxp.Data.Access.Adapters.DataAdapter.TryExecuteQuery(IDataAdapterExecutionContext executionContext, AdapterCredentialsValue credentials, SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)
   at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.<>c__DisplayClass5d.<>c__DisplayClass5f.<ExecuteQueryAndCreateTable>b__5b(CancellationToken token)
   at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.ExecuteAdapterMethod In 7.5 and 7.6, the Spotfire Connector software is a separate download and will need to be added within the new 7.5 or 7.6 deployment area.
 
Starting with 7.7, the connectors are part of the client deployment kit itself ,so when the latest deployment is added to the deployment area, the connectors will automatically be included.