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:
00622669
Vues:
38
>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 >
Al Williams

Anola MB, CANADA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform