Expand my Community achievements bar.

OLEDB Stored Proc w/ parameter

Avatar

Former Community Member
I'm trying to connect to a SQL Server DB to automatically fill certain form fields. I can create the connection, but then I am presented with a screen to select the data collection method - either Table, Stored Procedure, or SQL Query. I choose Stored Proc, but when I try to proceed I get the following error:



Stored Procedure has non-optional parameters.



How do I pass the stored procedure the parameter?
1 Reply

Avatar

Level 1

Hi,

As far as I know InDesign takes flat files or XML. Conversion may be required in database before input.

Imran