Stored Procedure with Parameter, can't connect to d.b.

[BillPeck]

I've set up a stored procedure in Sql Server with a paramater. I can run it fine in Query Analyzer.

When I select the stored procedure as the "table" in the Database Expert, it immediately asks for the parameter. So I just enter "A" but get an error message "Not Supported, Cannot obtain error message from server.

What do I need to do for this parameter?

Thanks.

 

[vidru]

Try clicking on the 'Set to Null Value' checkbox, or leave it blank.

dave

 

[BillPeck]

Dave,

excellent, leaving it blank worked, parameter comes up fine.

Thanks !

Bill