Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can a Stored proc call an exe
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00622580
Message ID:
00622677
Views:
36
I don't know, I never tried it.
Maybe you can make it into COM server and run using sp_OACreate and sp_OAMethod? Just an idea.

>>I don't think you can run application with GUI this way.
>
>Even though the program is written in VB - there is no user interaction - the app starts, does its thing, then closes. What would the difference be if I wrote a VFP prg and compiled in to an exe? It still wouldn't run using xp_cmdshell, would it?
>
>
>>
>>>>I think the problem is in the spaces in the dir name. Try
EXEC xp_cmdshell '"C:\Program Files\CU Solutions\Car2\car2.exe"'
>>>
>>>Thanks - I just tried that - the 'query' ran for a minute and then I stopped it - the program did not start. The exe in question is a VB exe.
>>>
>>>When I go Start/Run and then type in "C:\Program Files\CU Solutions\Car2\car2.exe" - the program starts right away. There must be something missing in the SQL query code.
>>>
>>>
>>>>
>>< snip >
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform