help using HTML/ASP to run a VBScript

[highlife]

using the #exec command in an html page, or some sort of command from ASP, i would like to run a .vbs script that opens a VSS database, gets a file from it and places it in a specific directory on the server. I cant simply run the script from an asp page because of memory constraints imposed on the site by IIS, the database is quite large.

i would like to know how to 1. pass a value to the script (a file name to get from the DB) 2. fire off the script on the server 3. return to the browser whereupon redirecting it to the file location on the webserver.

any help would be appretiated

thanks,
Zack

[kb244]

I can think of two ways, the first way is re-evaluate how you are using the database it is possible, to only retreive back the information you need, rather than filling a whole recordset.

the Other option is to look into RDS, since you were planning on using Vbscript anyways, I'm not going to stress the fact that it only works on IE, RDS is similar to ADO, the only difference is, that with RDS , the recordsets are pulled to the client side, and is cached there. I dont know too much about RDS , since I only use ADO and mostly serverside work.

[highlife]

actually i think the database is just a binary file or something like that.

the vbscript doesnt do any ADO or anything, it just interfaces with the Microsoft VisualSourceSafe COM object. I cant just pull out the records that i need. the script will work if used in windows scripting host on the server, but when i try to run it in an ASP page it gives the mem error. even tried using IIS to tell it to run out of process....didnt work.

[kb244]

Well theres your mistaken, you're opening the actual file itself into the IIS memory, try ADO, or some other database querying language. ADO is very easy on ASP.

[highlife]

the VSS database is sort of a unique one, its not a typical sql or access database. it is some sort of binary job that has pointers to all the files under source control which are compressed somewhere on the server.

im not trying to say that your solution is wrong, but for this situation i cant use ado to get to the database i have to use the COM object.

[kb244]

VSS? Visual SourceSafe?

[highlife]

yes