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

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

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

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Page: [1]


seth Posts: 312 From: canada Status: offline	Microsoft OLE DB Provider for ODBC Drivers error '80040... - 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 Posts: 312 From: canada Status: offline	RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 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?? < Message edited by seth -- 11/19/2003 3:21:24 PM > (in reply to seth)


Spooky Posts: 26598 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 11/19/2003 15:37:49 Whats the data type of ipA in the database? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to seth)


seth Posts: 312 From: canada Status: offline	RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 11/19/2003 15:55:24 it is "number" (in reply to Spooky)


seth Posts: 312 From: canada Status: offline	RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 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! (in reply to seth)


Spooky Posts: 26598 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 11/19/2003 18:40:19 Lol, the old spelling trick ;-) _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to seth)


ou812 Posts: 1548 Joined: 1/5/2002 From: San Diego Status: offline	RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 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 (in reply to Spooky)


pinklasies54 Posts: 1 Joined: 7/24/2007 Status: offline	RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 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 (in reply to seth)


rdouglass Posts: 9167 From: Biddeford, ME USA Status: offline	RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 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. ) _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to pinklasies54)