In MS Access... in Pass through query... when executing, I am getting this error 'ODBC - connection to STW failed'.
This is what I have in the Pass through query.
exec CaculateVariableFixedTimes '41428' , '2018-01-01' , '2'
The stored procedure works perfectly when I run it in SQL. This used to work properly when I had my SQL on my local machine. Now I am connecting to a server. I am guessing that is the issue. I am able to connect to my tables and queries properly.