ASPFAQS.com : Databases, Errors - 4GuysFromRolla.com

4GuysFromRolla.com : ASPFAQs : Databases, Errors

The Databases, Errors category contains the following FAQs:

Question: Why do I get a closed recordset from my stored procedure? Why don't I get the expected fields from the stored procedure?

[View the Answer!] Posted by Dutch at 11/21/2001 8:17:02 AM. (57,541 views...)

Question: Why do I get the error "The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another" when I try to open a recordset?

[View the Answer!] Posted by Bill Wilkinson at 6/11/2001 3:24:51 PM. (91,729 views...)

Question: Why does the .RecordCount property return a value of -1?

[View the Answer!] Posted by Scott Mitchell at 3/2/2001 4:29:29 PM. (63,999 views...)

Question: I'm getting an error (80020009) when trying to work with a value from a Memo (or text or blob) column. For example, I get this error when I do: Response.Write objRS(MemoColumnName)

[View the Answer!] Posted by Scott Mitchell at 3/2/2001 4:10:13 PM. (54,771 views...)

Question: Why do I get an error when I try to insert a value into a database that contains an apostrophe?

[View the Answer!] Posted by Scott Mitchell at 3/2/2001 3:58:24 PM. (49,332 views...)

Question: I am using Access and getting a 80004005 error (or a [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem?

[View the Answer!] Posted by Scott Mitchell at 1/17/2001 11:38:49 PM. (233,530 views...)

Question: ** UPDATED 24 June 2003 **: Why am I getting "Operation must use an updateable query" errors?

[View the Answer!] Posted by Scott Mitchell at 12/21/2000 6:38:47 PM. (119,416 views...)

Question: Why do I get the message Microsoft JET Database Engine error ' 80040e14' Syntax error in INSERT INTO statement??

[View the Answer!] Posted by Bill Wilkinson at 11/8/2000 9:01:22 PM. (61,560 views...)

Question: Why do I get a type mismatch error from my query? Why do I get the message Syntax error (missing operator) from my query? Why do I get a Too few parameters expected 1 error from my query?

[View the Answer!] Posted by Bill Wilkinson at 10/16/2000 5:49:54 PM. (61,107 views...)

[Return to the ASPFAQs Index] | [Suggest an FAQ]
Databases, Errors category viewed 144,882 times...

Do you have a FAQ you'd like to suggest? Suggestions? Comments? If so, send it in! Also, if you'd like to be a FAQ Admin (creating/editing FAQs), let me know! If you are looking for other FAQs, be sure to check out the 4Guys FAQ and Commonly Asked Messageboard Questions!

Most Viewed FAQs:
1.) How can I format numbers and date/times using ASP.NET? For example, I want to format a number as a currency. (761643 views)
2.) I am using Access and getting a 80004005 error (or a [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem? (207777 views)
3.) How can I convert a Recordset into an array? Also, how can I convert an array into a Recordset? (202549 views)
4.) How can I quickly sort a VBScript array? (196039 views)
5.) How can I find out if a record already exists in a database? If it doesn't, I want to add it. (156019 views)
6.) How do I display data on a web page using arrays instead of Do...While...MoveNext...???... (152331 views)
7.) When I get a list of all files in a directory via the FileSystemObject, they aren't ordered in any reasonable way. How can I sort the files by name? Or by size? Or by date created? Or... (140381 views)
8.) For session variables to work, must the Web visitor have cookies enabled? (110162 views)
9.) Can I send emails without using CDONTS? (107083 views)
10.) How can I take the result of a SELECT...MULTIPLE or a group of same-named checkboxes and turn it into a query? That is, if the user selects 3 answers, how can I construct a query that looks for all 3? (106308 views)
Last computed at 9/17/2007 3:22:00 AM

Software Developer / Programmer - Distributed Systems (NYC)
Next Step Systems
US-NY-New York

Post A Job | Post A Resume