Showing posts with label code. Show all posts
Showing posts with label code. Show all posts

Thursday, March 27, 2008

ASP VBScript Database Accessor Class

I've got some limitations with a web server I've been working with. It doesn't have support for .net assemblies, so I can't write web applications in Visual Studio 2005. This leads me to think of creative ways to handle functionality.

Anyways, I came up with an idea of creating a class in VBScript (ASP), where I could send post data to a script on the server that would in-turn access the database file and do what it needs to do. I took it one step further, where all talk between client and server is XML. So the client sends "mock" SQL in the from of XML and in turn receives a response in XML saying if it worked, or returning data from the database.

I'm releasing the code under the Lesser GPL here (revised 04/09/2008):
http://www.netnobi.com/software/lgplaccessdatabase.php

I fixed quite a few errors that I ran into while using the class recently. I also added a few features to the select type xml that can processed by the class.