Posted by Erland Sommarskog on 06/06/07 21:27

Ben (pillars4@sbcglobal.net) writes:
> This is the current scripts of the application:
>...
> .Parameters.Append .CreateParameter("ItemNumber", adVarChar,
>adParamInput, MyItemNumber)
> .Parameters.Append .CreateParameter("TotalInStock", adInteger,
> adParamOutput, MyTotalInStock)
> .Parameters.Append .CreateParameter("TotalCost", adCurrency,
> adParamOutput, MyTotalCost)

Here is an error: .CreateParameter takes five parameter of which the
fourth is the size, and the fifth is the value. Thus you need to insert
an extra comma after adParamInput, adParamOutput.

> Unfortunately, I still get the same error. But this time, I get it in a
> second.

Well, at least some progress. :-)
--
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

• Next in forum: Re: Linux Servers(Usage)
• Prev in forum: Re: SQLServer Table Partitioning
• Thread view: Re: ADODB Command (Stored Procedure)

[Reply to this message]