Error Type:0x80040E57 and ADODB.Command error '800a0d5d'
i have come to the conclusion i have problem in one of two areas and ive
spent two days tring to figure it out.
First the error i get is below with this code:
ParamList(1) = reportDate
ParamList(0) = month(reportDate) & "/1/" & Year(reportDate)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)
[Oracle][ODBC][Rdb]%RDB-E-ARITH_EXCEPT, truncation of a numeric value at
runtime -SQL-F-DATCONERR, Data conversion error for string '1109-20-05'
-COSI-F-IVTIME, invalid date or time
/PICKLER/common/connect.asp, line 201
So i though oh in my code i have to prepend the pound sign in this part
of the code below:
ParamList(1) = "#" & reportDate
ParamList(0) = "#" & month(reportDate) & "/1/" & Year(reportDate)
But now i get an error:
ADODB.Command error '800a0d5d'
Application uses a value of the wrong type for the current operation.
/PICKLER/common/connect.asp, line 195
The code on this line 195 is:
Cmd.Parameters.Append Cmd.CreateParameter(TempName, TempType,
adParamInput, 50, TempParam)
What did i do wrong?
Any help would be greatly appeciated!!
*** Sent via Developersdex http://www.developersdex.com ***
|All times are GMT. The time now is 04:48 AM.|
Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.