i have designed a stored proc in my db to insert a record and to check if 

the record is already present and if it is then it just updates that 

record on the basis of a unique itemcode.



i have tried entering values in my query analyzer and it works perfectly 

fine. but teh same done from my asp page generates follwoing error



Microsoft OLE DB Provider for ODBC Drivers error '80040e21' 



Multiple-step OLE DB operation generated errors. Check each OLE DB status 

value, if available. No work was done. 



/skytronik/www/admin/csvimport/tee.asp, line 53 



the code for my asp page is below

<%



set Command1 = Server.CreateObject("ADODB.Command")

Command1.ActiveConnection = MM_phones2_STRING

Command1.CommandText = "taher.prodcsv"

Command1.CommandType = 4

Command1.CommandTimeout = 0

Command1.Prepared = true

Command1.Parameters.Append Command1.CreateParameter("@catid", 3, 1,5,123)

Command1.Parameters.Append Command1.CreateParameter("@itemcode", 130, 

1,50,Command1__itemcode)

Command1.Parameters.Append Command1.CreateParameter("@proddesc1", 130, 

1,1000,Command1__proddesc1)

Command1.Parameters.Append Command1.CreateParameter("@price", 4, 

1,8,Command1__price)

Command1.Parameters.Append Command1.CreateParameter("@stock", 130, 

1,9,Command1__stock)

Command1.Parameters.Append Command1.CreateParameter("@vat", 131, 

1,9,Command1__vat)

Command1.Parameters.Append Command1.CreateParameter("@weight", 131, 

1,9,Command1__weight)

Command1.Execute()



%>





plz let me know of any suggetions you may have

thanks in advance