ADODB.Recordset error ‘800a0bb9’ : Arguments are of the wrong type

by

The most like cause is that you haven’t included “ADOVBS.INC” or the equavalent META:-

<!--METADATA
TYPE="TypeLib"
NAME="Microsoft ActiveX Data Objects 2.6 Library"
UUID="{00000206-0000-0010-8000-00AA006D2EA4}"
VERSION="2.6"
-->

Hence the adxxxx constants do not exist. However your primary mistake is not including Option Explicit at the top your script. This will save you bucket loads of time hunting silly mistakes and typos.

BTW What happens if ATTUserDataID contained “0; DELETE ATTJournals;” ?
Avoid composing SQL using concatenation like the plague. Search for “ASP SQL Injection” to find examples of using parameterised command objects instead.

More Related Contents:

  1. Detailed 500 error message, ASP + IIS 7.5
  2. How to upload files with asp-classic
  3. How do I properly instantiate 32-bit COM objects in classic ASP after installing Windows Update KB4340558?
  4. convert utf-8 to iso-8859-1 in classic asp
  5. ASP: request.form is not returning value?
  6. How to enable ASP classic in IIS7.5
  7. Querying Active Directory using VBScript
  8. Is codepage 65001 and utf-8 the same thing?
  9. How to resolve “The requested URL was rejected. Please consult with your administrator.” error?
  10. How to encrypt in VBScript using AES?
  11. How to read CSV files line by line in VBScript
  12. Format current date and time in VBScript
  13. Convert UTF-8 String Classic ASP to SQL Database
  14. Regex to split a CSV
  15. Classic ASP SQL Injection Protection
  16. How do you debug classic ASP?
  17. Using Stored Procedure in Classical ASP .. execute and get results
  18. Update div with jQuery ajax response html
  19. Classic ASP – How to convert a UTF-8 string to UCS-2?
  20. ASP JSON: Object not a collection
  21. How do I enable upload of large files in classic ASP on IIS 7?
  22. Pure ASP upload with image detection
  23. Sharing cookies across different domains and different applications (classic ASP and ASP.NET)
  24. How to make a parametrized SQL Query on Classic ASP?
  25. Building a COM interop library for ASP Classic using 4.0 framework and Visual Studio 2010
  26. Accessing a request’s body using classic ASP?
  27. IIS URL Rewrite ASP
  28. Classic ASP (VBScript) convert HTML codes to plain text
  29. How to perform an HTTP POST request in ASP?
  30. Classic ASP : C0000005 Error on execution

Leave a Comment