Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kelvintung
Starting Member
1 Post |
 Posted - 2012-02-17 : 03:44:26
|
| Hi guys, I am trying to use the "xp_cmdShell" to call the api(ffsend.exe) and send out a fax through the Fax Server - FAXFINDER's Client, my stored procedure contains something like:......xp_cmdshell 'D:\fax\ffsend.exe D:\fax\spec.txt'...which will call the ffsend.exe api and insert the fax to the queue.This sp works prefectly on sql 2005(32bit)+windows server 2003 (32 bit). However, after i switch the platform to sql server 2008(64bit)+windows server 2008(64bit), the result doesn't come out as expected.The Stored Procedure can run successfully under the 64 bit platform, and the API(ffsend.exe) returns the value as expected. But the fax just can't add to the fax queue in the Faxfinder's client program. After doing some research on the web, my guess is that the Faxfinder's client program(ff110client.exe) ran as 32bit(I can see the *32 on Task Manager) but when I use the xp_cmdshell to trigger the ffsend.exe api, it will acctullay run as 64 bit, so the Client program and the API cannot be interconnected and that's why the fax queue can not be insert to the Client Program.So my question is,is there any way to specify the xp_cmdshell to run the api as 32 bit? or is there any other way that will fix my problem? Any Ideas?P.S. The "ffsend.exe" runs perfectly at the command prompt(in both 32bit and 64 bit platform), it just doesn't work when it is called by "xp_cmdshell" .Regards,Kelvin |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-17 : 07:34:19
|
| SQL Server service account has permissions on the executable?UAC is disabled?By the way, would likely to be better to queue the faxes and have a seperate job send 'em, rather than do that from the stored procedure. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-17 : 14:09:10
|
| are you using it inside sql job?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
xp_cmdshell run as 64 bit?