xp_cmdshell - Problem running perl script from xp_cmdshell 
Author Message
 xp_cmdshell - Problem running perl script from xp_cmdshell

I have a perl script on a NT Server in the D:\Perl\Bin directory.  I can
run this happily from a cmd prompt on the server with the command :
D:\Perl\Bin\perl -ID:\perl\lib D:\perl\bin\check.pl

BUT when I try to run the same command from an SQL trigger on SQL Server
6.5 (from a web page), using the xp_cmdshell function, i.e. :
exec master..xp_cmdshell "D:\Perl\Bin\perl -ID:\perl\lib
I get the error "Can't call method "Sql" without a package or object
reference at D:\perl\bin\check.pl line 20. "

The perl script uses various Perl libraries, which I think are causing the
problems, as a simple one line perl script works OK.   Has anyone else come
across this problem?  Can anyone offer any advice?

Best Regards,

Richard Tinker          Finance Division
Logica UK Ltd.          

Sat, 23 Oct 1999 03:00:00 GMT
 xp_cmdshell - Problem running perl script from xp_cmdshell

xp_cmdshell seems to have trouble with locating supporting files and
stuff.  I find I get better results if I wrap up my commands in a
batch file and call that.

Hope this helps!

Replys can sent to Mgoulard(at)cygnus.nb.ca

<Fake EMail addresses follow:>

Sun, 24 Oct 1999 03:00:00 GMT
 [ 2 post ] 

 Relevant Pages 

1. Error running ftp script from xp_cmdshell

2. Error using xp_cmdshell to run DTS script

3. problem using xp_cmdshell in .idc script

4. Problem running xp_cmdshell calling Powerbuilder module

5. xp_cmdshell and PERL files

6. xp_cmdshell calling WSH Script

7. Script with xp_cmdshell says- no printer installed

8. Using xp_cmdshell to call .vbs script

9. Slow running bcp in to SS7/sp3 using xp_cmdshell

10. Using xp_cmdshell to run BCP...

11. running xp_cmdshell

12. Stored proc will not run xp_cmdshell

Powered by phpBB® Forum Software