Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can a Stored proc call an exe
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00622580
Message ID:
00622677
Vues:
34
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform