I read values from one table into variables(they are

nvarchar in original table).  Then I try to insert

them into another table as nvarchar.  I keep getting

this error.  I also tried to change the field from

nvarchar to datetime, but I get cannot convert error.

Please help 

Set cx = Server.CreateObject("ADODB.Command") 

Set p = cm.Parameters 

cx.ActiveConnection = dbConn 

cx.CommandText = "sp_Insert_MonthlyBatch_2" 

cx.CommandType = adCmdStoredProc 



p.Append cx.CreateParameter("@ResponseCode",

adInteger, adParamInput) 

p.Append cx.CreateParameter("@AuthCode", adVarChar,

adParamInput,100) 

p.Append cx.CreateParameter("@AVSR", adVarChar,

adParamInput,50) 

p.Append cx.CreateParameter("@TransID", adVarChar,

adParamInput,100) 

p.Append cx.CreateParameter("@TimeStamp", adVarChar,

adParamInput,100) 

p.Append cx.CreateParameter("@CCNum", adVarChar,

adParamInput, 50) 

p.Append cx.CreateParameter("@CCExpDTM", adVarChar,

adParamInput,50) 

**************output************* 

29-Dec-2000 10:58:03 AM CST 

012001 

4222222222222 





ADODB.Command error ' 800a0d5d' 



Application uses a value of the wrong type for the

current operation. 



/test/update_batch.asp, line 154 



**************output************* 

It is set as nvarchar in database table





--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com