Pop-Up Thingie
Sidebar
>>> Magnum BBS <<<
Home
Forum
Files
Dark
Log in
Username
Password
Sidebar
Forum
Usenet
COMP.DATABASES.MYSQL
MS SQL Server: run external program
From
Ammammata
@21:1/5 to
All
on Thu Jul 29 10:43:20 2021
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 ] ...........
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
Who's Online
Recent Visitors
Cronus
Mon Apr 22 20:57:16 2024
from
Provo, Ut
via
SSH
Keyop
Mon Apr 22 13:23:46 2024
from
Huddersfield, West Yorkshire
via
SSH
Keyop
Tue Apr 23 10:35:46 2024
from
Huddersfield, West Yorkshire
via
SSH
Keyop
Tue Apr 23 10:35:37 2024
from
Huddersfield, West Yorkshire
via
SSH
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
295
Nodes:
16 (
2
/
14
)
Uptime:
00:58:31
Calls:
6,642
Calls today:
2
Files:
12,190
Messages:
5,325,417