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
D:\perl\bin\check.pl"
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
--
==============================================================
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