OK, I don't know why I'm having such a hard time with this, I used to be able to write this code in my sleep.

So, I've cut my parameters down to 2 for the sake of quick debugging. I don't have an output parameter declared, just a return. The SP works in Analyzer and returns ID.

I've tried just calling the proc, ie: execute sp_New "Block1", "Lot2"
This inserts the record but I can't return anything.

So, I tried creating the parameters...
CmdSP.Parameters.Append(CmdSP.CreateParameter("@Block", adVarChar, adParaminput, 2, rsEDI("block").Value))

But that doesn't seem to work either. I'm getting a database locked error or something like that.

I used to have a little add-in that I downloaded from Microsoft that automatically created your parameters for each proc, but I can't find it any more.
I can't seem to find anything on parameters for procs in VB.net.
Any suggestions?