I am making a connection using odbc, and the connection test works for me, but when making a query, I get an error:
Source System.Activities
Message: The argument reason is null or empty. Parameter name: reason
Exception Type: ArgumentException
I am making a connection using odbc, and the connection test works for me, but when making a query, I get an error:
Source System.Activities
Message: The argument reason is null or empty. Parameter name: reason
Exception Type: ArgumentException
You have a parameter named ‘reason’ that is null or empty. You have to assign the value to the parameter in the parameters pop-up window, then reference the parameters within your SQL statement.
With ODBC, I believe you reference parameters sequentially with a ?
symbol. If that doesn’t work try @ParameterName
(case sensitive) or :ParameterName
(also case sensitive)