I'm kind of new to attempting this sort of thing and I have some unique restrictions, so please bear with me.
I am attempting to connect to data in a SQL database through stored procedures in my SharePoint 2007 site. I do not have access to central administration and cannot establish a BDC. I am also restricted from using custom web parts.
When I set up the insert command, I would like to be able to return the id created using an OUTPUT parameter in the stored procedure.
When I attempt to add parameter bindings for the sprocs in the Command and Parameter Editor, it looks like it is possible to specify that the direction is output, however, I have no idea how to specify what to output it as. I cannot name the output parameter unless I have a parameter source, but there is no parameter source (e.g. Form, QueryString, Control, etc).
I'll keep fiddling around with it until I make it work or give up, but if anyone can provide a pointer, I would greatly appreciate it.