Cscript from a SQL Stored Procedure?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Carlos (Carlos_at_discussions.microsoft.com)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 14:27:04 -0700

Hopefully, someone can help me out with this.

I'm trying to run a .vbs script using cscript from a stored procedure that
gets called from a powerbuilder application (our commerce software)
that uses SQL SERVER 2000 as it's database.

Basically we are trying to add code that calls the .vbs script so that when
an invoice prints it also calls the .vbs script to print a packing list as
well.

The .vbs file simply formats some data, and creates a file.

I can run everything fine from Query Analyzer, however when the
stored procedure gets called from the application. I get this error :

CScript Error: Loading your settings failed. (Access is denied.)

Here is how the .vbs script is being called :

DECLARE @STR varchar(255)
SET @STR = 'cscript //nologo c:\PACKING_LIST.vbs 2265440 > c:\OUTPUT.DAT'
exec master..xp_cmdshell @STR, NO_OUTPUT

2265440 is simply an invoice no passed in as a parameter.

I've been able to establish that xp_cmdshell does run. Using :

SET @STR = 'dir /p > c:\OUTPUT.TXT'

I was able to get the directory listing redirected to the output.txt file
successfully.
However, when the stored procedure is being called from the application
'cscript'
doesn't seem to execute.

Also our SQL Server is running under an administrator login, versus sa.

Any help is appreciated.

Carlos

Relevant Pages

  • cscript errors when running many concurrent vbs scripts
    ... i have a java application that spawns cscript to run a simple vbs script ... concurrent calls are made some of the cscript invocations will fail in the ... * exit code -1073741502, no stdout/stderr ... stdout = CScript Error: ...
    (microsoft.public.scripting.wsh)
  • Re: Calling a .Net assembly from a SQL2000 procedure
    ... I'm not sure if this can be done, but I usually start w/a VBS script, debugg it ... a .Net assembly from a stored procedure, many threads reference the Microsoft KB ... Load CLR in SQL Server Is Not Supported". ... > I've tested the above scenario and I can call the .Net assembly from a stored ...
    (microsoft.public.sqlserver.programming)
  • Re: Calling a .Net assembly from a SQL2000 procedure
    ... > simple VBS script for a simple Hello World .Net Assembly. ... > HTH ... > a .Net assembly from a stored procedure, ... > IN-PROCESS in the SQL Server memory space. ...
    (microsoft.public.sqlserver.programming)
  • using cscript.exe and vvbs script for file-stored inputs
    ... He gets a Matlab file to write a .vbs script. ... So basically cscript gets the inputs from test2.vbs and inputs them to ... it is that you don't even need to interface other language code with ...
    (comp.soft-sys.matlab)
  • Re: How to add multiple computers into collection
    ... theres a great vbs script called colladd.vbs by Mark Nunn that ... cscript /nologo Colladd.vbs smsserver filename collectionID ... We are using SMS 2003 in our organization. ... created a collection and asked me to add computers into it. ...
    (microsoft.public.sms.admin)