You will have to take the value to a variable first then you may need to make EXEC call. EXEC call expects variable only and dont perform concatenation operation.

So...

From SQL Server 2014 onwards , MS have changed Cardinality Estimator. This has improved some of the application, while degraded some of the queries drastically leading to roll back or...

I had a similar issue, the workaround I found was removing all spaces , hopefully may be helpful (may work for some)

I changed my connection string

Data Source=ABCD;User ID=USERNAME;Password=PASSWIORDHERE;Initial Catalog=DBNAMEHERE;Provider=SQLNCLI11;

SERVER=ABCD;UID=USERNAME;Password=PASSWIORDHERE;DATABASE=DBNAMEHERE;Provider=SQLNCLI11;

Worked...