Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

seth -> Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (11/19/2003 15:09:24)

I was trying to insert a new record into the database which has the correct folder permissions, when i got this 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. 

<%
Set connDB = Server.CreateObject("ADODB.Connection")
	connDB.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("\prr2b\ad4ba1.mdb") & ";"
        Set RS = Server.CreateObject("ADODB.Recordset")
            RS.Open "captured", connDB, 1, 3, 2


RS.AddNew
RS("id") = id
RS("ipA") = IPn  //response.write IPnum give a value of 2392925859
RS.Update

RS.Close
Set RS = Nothing
connDB.Close
Set connDB = Nothing
%>

the ipA column is set to long interger and id is the primary key column that is non duplicate autonumber.

Any ideas as to the error?



seth -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (11/19/2003 15:19:45)

OK i got rid of the RS(id) = id and now i have a new error:
Provider error '8002000a'
Out of present range.

I looked it up and this is what I found: 
This is usually caused when you pass a numeric value too 
large for the data type, when using a ADODB.Command. 
For example, sending 2^32 to a parameter using adInteger. 
A decent way to avoid this strong typing issue altogether is to 
avoid the command object and use 
connectionObject.Execute("EXEC procName").


I don't understand how to associate this to my problem??



Spooky -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (11/19/2003 15:37:49)

Whats the data type of ipA in the database?



seth -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (11/19/2003 15:55:24)

it is "number"



seth -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (11/19/2003 16:12:27)

Thanks for the "Thinking" spell Spooky, I canged the value from a number to text and all works great!



Spooky -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (11/19/2003 18:40:19)

Lol, the old spelling trick ;-)



ou812 -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (2/24/2004 21:41:52)

Whew! Glad I found this. I just got this error "Out of present range" on one of my sites and it ended up being one of my columns was supposed to be a long int but was only int. So, this post saved me quite a bit of time!

thanks! [:)]

-brian



pinklasies54 -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (7/24/2007 21:33:41)

OLE DB Drivers error '80040e21'

help please

HELP WITH THI PROBLEM PLEASE
WOULD BE APPRECIATED ., IM NOT A GEEK , BUT NOT STUPID, CAN YOU HELP ME PLEASE??????//

LADY IN DISTRESS
THANKING YOU
KIND REGARDS



rdouglass -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' (7/24/2007 22:16:24)

Hi and Welcome to OutFront.

This is quite an old post you resurrected.

What kind of database are you using and can you post your query and connection code?

(and could you unlock your CAPS. [;)] )



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
7.617188E-02