Passing Parameters to a Stored Procedure using ASP

by

@KekuSemau is correct but let me a suggest a more efficient and manageable approach then using the adovbs constants file.

METADATA allows you to define a reference to the DLLs constants even if your using Late Binding as is the case in a Classic ASP environment. It’s probably worth mentioning that you can add METADATA references in individual pages but then again why would you?

To use it simply add the METADATA tag to your global.asa file (should be located in the root of your Web Application).

<!-- 
METADATA TYPE="typelib" FILE="C:\Program Files\Common Files\System\ADO\msado20.tlb"
-->

Depending on the system the ADO Type Library maybe different, adjust the FILE attribute accordingly.

I use this approach in all my applications mainly for referencing constants in the ADO and CDO Type Libraries.

ADO Type Library

<!--
METADATA 
TYPE="typelib" 
FILE="c:\program files\common files\system\ado\msado15.dll"
-->

CDO Type Library

<!-- 
METADATA 
TYPE="typelib" 
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D" 
NAME="CDO for Windows 2000 Library"
-->

These are examples of my own personal references, file locations maybe different whereas UUID attributes should be exactly the same.

IMPORTANT:

Remember to remove any references to adovbs constant include file (adovbs.inc or adovbs.asp commonly) when using METADATA approach in your global.asa or you will get a

Name redefined error

Also METADATA is only available in IIS 4.0 and above.

Useful Links

More Related Contents:

  1. ADODB.Parameters error ‘800a0e7c’ Parameter object is improperly defined. Inconsistent or incomplete information was provided
  2. Out of memory Microsoft VBScript runtime error 800a0007
  3. How do I run a VBScript in 32-bit mode on a 64-bit machine?
  4. Parameterized query in Classic Asp
  5. Error trying to call stored procedure with prepared statement
  6. Error ASP 0177: 8007007e CreateObject fails for COM DLL
  7. Any good libraries for parsing JSON in Classic ASP? [closed]
  8. How can I post data using cURL in asp classic?
  9. Can I pass an argument to a VBScript (vbs file launched with cscript)?
  10. Read and write into a file using VBScript
  11. Creating multi-select list box in VBScript [closed]
  12. Does VBScript allow named arguments in function calls?
  13. How do I sort arrays using vbscript?
  14. Access network share from within VBScript eg FileSystemObject
  15. Lists in VBScript
  16. Order of Files collection in FileSystemObject
  17. ASP: request.form is not returning value?
  18. How can I use Clipboard in vbscript? [duplicate]
  19. Passing-variable-from-vbscript-to-batch-file with arguments
  20. Can I pick up environment variables in vbscript WSH script?
  21. VBscript relative path
  22. Querying Active Directory using VBScript
  23. How to use GetObject in VBScript
  24. Vbscript list all PDF files in folder and subfolders
  25. Can not send mail using smtp.gmail.com, port 587 from vbs script
  26. insert a variable to cmd command
  27. Creating and writing lines to a file
  28. How to resolve “The requested URL was rejected. Please consult with your administrator.” error?
  29. Classic ASP (VBScript) convert HTML codes to plain text
  30. Is the Sleep operation no longer used in VBscript?

Leave a Comment