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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 xp_cmdshell executing 32bit exe on SQL x64

Author  Topic 

Scott
Posting Yak Master

145 Posts

Posted - 2008-01-11 : 15:35:34
Here is a post to the MSDN forums that I have not been able to resolve:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2663783&SiteID=1

Anyone here have any ideas?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2008-01-11 : 15:59:06
in step TYPE dropdown, change to operating system command. then just put in your command
Go to Top of Page

Scott
Posting Yak Master

145 Posts

Posted - 2008-01-11 : 17:08:08
quote:
Originally posted by russell

in step TYPE dropdown, change to operating system command. then just put in your command



I've tried that and it does the same.
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2008-01-11 : 18:01:22
in taskmgr on server, do u see processes running? may need to kill them.

have u applied SP2?

i never had this problem, and do run some command scripts this way.

hate to say it, but...tried rebooting server?

nothing in event logs?
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-01-11 : 21:26:16
what is the exact syntax of the command you are using to execute the 32bit command? I have a feeling you have a syntax error there. You have to use double quotes not single quotes when specifying the path.



-ec
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-12 : 00:25:48
Tried call it with xp_cmdshell in query window?
Go to Top of Page

Scott
Posting Yak Master

145 Posts

Posted - 2008-01-14 : 11:33:27
quote:
Originally posted by rmiao

Tried call it with xp_cmdshell in query window?


Yes, I've tried this:
exec master.dbo.xp_cmdshell 'c:\WINDOWS\SysWOW64\cmd.exe /C c:\tmp\test.bat'

Does not work but this from DOS does:
c:\WINDOWS\SysWOW64\cmd.exe /C c:\tmp\test.bat

?
Go to Top of Page
   

- Advertisement -