MS SQL Server: run external program
Ammammata <[email protected]> Thu, 29 Jul 2021 10:43:20 -0000 (UTC)
| Newsgroups | comp.databases.mysql |
|---|---|
| Message-ID | <[email protected]> |
Hi I'm trying to run MS Access runtime, with my procedure and an additional parameter the command line is MSACCESS.EXE c:\Sviluppo\QCT\QCT1000.mdb ;255 without path, being it already included in the PATH variable this command works fine when I use the "Run" window when I try this command from within MSSMS EXEC xp_cmdshell 'MSACCESS.EXE c:\Sviluppo\QCT\QCT1000.mdb ;255'; GO I get the error: output 'MSACCESS.EXE' is not recognized as an internal or external command, operable program or batch file. NULL If I include the path in the command line EXEC xp_cmdshell '"C:\Program Files\Microsoft Office\Office16\MSACCESS.EXE" c:\Sviluppo\QCT\QCT1000.mdb ;255'; GO it goes into a loop and I have to kill MSSMS to exit Note that I'm not sure how to use "" because of the space in the path between words Microsoft and Office Any suggestion is welcome -- /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\ -=- -=- -=- -=- -=- -=- -=- -=- - -=- ........... [ al lavoro ] ...........