Create WScript.Shell on IIS (Server)

[brianrose]

I am working an a web project that has to save a lot of data to flat files from SQLServer using dynamic querys and this causes connection time outs. To over come the problem I am trying to use the osql utility. I need to run the utility as a command on the Server to do this I need to create a WScript.Shell and then use the Run method to execute it. But I have the problem of cannot create the object. Please help.

 

[caf]

"But I have the problem of cannot create the object"

What exactly do you mean?
What is the error you're getting?
Is it perhaps "ActiveX component can not create object"?

Do you have Windows Scripting Host installed or correctly installed?

BTW: Why don't you consider using xml?
The ADODB.RecordSet object can persist data returned from sp's etc to hard disk.

 

[brianrose]

IIS Does allows me to create the WScript.Shell Object on the Server but wont let me call and external executable. A simple trial is to create a WScript.Shell Object and use the run method of it to run notepad on the server. It does not allow this to take place. In fact notepad is opened as a process that is running some where inside the IIS module and causes the IIS Server not shutdown because of pending jobs like this notepad process.

 

[caf]

Hi

Why don't you post the trial code where you try opening notepad.exe. The reason is because I've run something similar & it works on my NT Server.

regards
caf