Posted by jbonifacejr on 12/01/06 19:26

Thanks Erland...I see where I screwed up. I thought I had explained
what was wrong, but I did that in a different thread in another forum.

Anyway, I got this working using classic ASP and ADODB. Now I am going
to try to get it working over ASP.NET and ADO.NET. Wish me luck.

So far, eveerything works except that I am constantly being told that
the stored procedure expects a parameter that was not supplied.
However, The same two parameters are created and added to the
Parameters of the command object.

I'll continue to work on it and see if I can get it to work. Looks like
I need a datareader or some other object. I found a great KB article
that basically shows me everythig I am doing (right and wrong)...

http://support.microsoft.com/kb/306574


Erland Sommarskog wrote:
> jbonifacejr (jbonifacejr@hotmail.com) writes:
> > If you look at the top post you will see where I put the code I am
> > using.
>
> Since then you changed the code according to Gert-Jan's advice, and we
> don't know what it looked after that.
>
> Basically, if you only say "not working" without specifying why, and
> don't show us the code, don't expect that much help. But that's your call.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]