I am adding a task to a job that runs a stored procedure with some parameters.

When I select the stored procedure to run from the drop down list of stored procedures, the parameters required for the stored procedure do not appear. Is there a known reason that may cause the parameters to not appear after a stored procedure is selected?

Clicking refresh parameters does not do anything. The application just thinks for a bit and then flashes with no parameters appearing.

1. which version are you running
2. what kind of database?
3. is it direct mode, odbc or oledb?

---

We are using version 8.2.1
It is a SQL database. The connection string is: Driver={SQL Server};Server=USPK10SQL;Database=AgressoCAM3;Trusted_Connection=Yes;
I believe that would be a direct mode connection.

We are using version 8.2.1
It is a SQL database. The connection string is: Driver={SQL Server};Server=USPK10SQL;Database=AgressoCAM3;Trusted_Connection=Yes;
I believe that would be a direct mode connection.

Did you use the guide to create the Connection string? Or did you use the Connection string alternative?

---

We are using version 8.2.1
It is a SQL database. The connection string is: Driver={SQL Server};Server=USPK10SQL;Database=AgressoCAM3;Trusted_Connection=Yes;
I believe that would be a direct mode connection.

Did you use the guide to create the Connection string? Or did you use the Connection string alternative?

Yes, used the connection guide.

Storage Type Database, Database type SQL Server. Data Provider MSSQL.
Trusted Connection: Data Source -> uspk10sql
Initial Catalog -> AgressoCAM3
Integrated Security SSPI

It is very strange. Do you get any errors in the log_serverDATE.txt when this occurs?

---

Nothing specific. I searched for error and I only saw:
Standard Error count: 7
But all log lines were marked 'Debug'.

What is the refresh parameters button supposed to do?

Nothing specific. I searched for error and I only saw:

Standard Error count: 7
But all log lines were marked 'Debug'.

What is the refresh parameters button supposed to do?

Refresh should reload parameters. Nothing happens when you click there I suppose?

---

Correct. The machine appears to be thinking for a bit, then a flash and nothing appears.

I checked the event viewer and the log files on the server and it doesn't seem like any entry is made in either of them when I click Refresh Parameters.

We identified a way to get the parameters to appear. If the SQL connection is created with Integrated Security alternative syntax then the parameters don't appear. If the connection is made with Integrated Security then the parameters are appearing for us.

I see, thanks for the feedback and information!

---