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
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
On 29/07/2021 12.43, Ammammata wrote:
Hi there,
this is a MySQL forum and has nothing to do with mssql or ms-access, so adding c.d.ms-sqlserver and c.d.ms-access which also been follow-up to.
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
Office\Office16\MSACCESS.EXE"If I include the path in the command line
EXEC xp_cmdshell '"C:\Program Files\Microsoft
c:\Sviluppo\QCT\QCT1000.mdb ;255';
GO
it goes into a loop and I have to kill MSSMS to exit
J.O. Aho (us...@example.net) writes:
On 29/07/2021 12.43, Ammammata wrote:
Hi there,
this is a MySQL forum and has nothing to do with mssql or ms-access, so adding c.d.ms-sqlserver and c.d.ms-access which also been follow-up to.
In *your* PATH variable. SQL Server runs under a service account, soI'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
it does not have your PATH.
So when you run that command line directly, what happens? Specifically,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
does it open a UI?
SQL Server runs as a service and does not have a desktop, so running
anything which has a UI is not going to work out.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 19:53:27 |
Calls: | 6,646 |
Calls today: | 1 |
Files: | 12,190 |
Messages: | 5,327,383 |