I though I'd share another one of the VBScript classes that I wrote that I've been using quite a bit of lately. I use SQL Server's stored procedures for nearly all my web application data access and I was getting sick of creating ADO connection objects and adding all the necessary parameters in with the correct data types (especially when the stored procedure had twenty-plus parameters). I did some searching to see if there was a way to automate the task. I found a way to query SQL server for stored procedure parameter information. I took that data, load it into an XML object, and create my VBScript code with an XSL transformation. I call it my VBScript SQL Server Coding Helper.
Posted by Matthew at June 30, 2004 03:30 PM