Message-ID:

I can't drive 55. I'm looking forward to not being able to drive 65, either.

devel / comp.databases.mysql / Re: MS SQL Server: run external program

MS SQL Server: run external program

<XnsAD76816DCF4AFammammatatiscalineti@127.0.0.1>

https://www.rocksolidbbs.com/devel/article-flat.php?id=24&group=comp.databases.mysql#24

copy link Newsgroups: comp.databases.mysql

Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!reader5.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From: ammammata@tiscalinet.it (Ammammata)
Newsgroups: comp.databases.mysql
Subject: MS SQL Server: run external program
Date: Thu, 29 Jul 2021 10:43:20 -0000 (UTC)
Message-ID: <XnsAD76816DCF4AFammammatatiscalineti@127.0.0.1>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 29 Jul 2021 10:43:20 -0000 (UTC)
Injection-Info: solani.org;
logging-data="16815"; mail-complaints-to="abuse@news.solani.org"
User-Agent: Xnews/??.01.30 Mime-proxy/2.3.c.1 (Win32)
Cancel-Lock: sha1:hVZDFos4Qd1nyQ4t8ci6ND4d3ZA=
X-User-ID: eJwFwYEBgDAIA7CXQNoC5wx0/59gwpBrE6LAy5sSCpr3/UxFs7EaYInahc9Z7s3wJzorW96ZyOBpH8PgBy8jFCE=
X-Face: s5/Tl9"^@"z`/]&NeE,Wl.^B~E2x9PA?1n:XZq2^T2Prz*},H~M'2.*@~v9MXx|OL8<EqC0MU$v+`Pu;`eq$N12\Nc*)cp$iBgD/wysO=)P%n6)\Xf}L\E$-0s\mD::Dx\6QwNh<U!LBH1Xj(=zy?OV.|=]We",DS\6[:

by: Ammammata - Thu, 29 Jul 2021 10:43 UTC

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 ] ...........

Re: MS SQL Server: run external program

<imfl3pFios7U1@mid.individual.net>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=26&group=comp.databases.mysql#26

copy link Newsgroups: comp.databases.mysql comp.databases.ms-access comp.databases.ms-sqlserver
Followup: comp.databases.ms-sqlserver,comp.databases.ms-access

Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: user@example.net (J.O. Aho)
Newsgroups: comp.databases.mysql,comp.databases.ms-access,comp.databases.ms-sqlserver
Subject: Re: MS SQL Server: run external program
Followup-To: comp.databases.ms-sqlserver,comp.databases.ms-access
Date: Thu, 29 Jul 2021 14:26:33 +0200
Lines: 60
Message-ID: <imfl3pFios7U1@mid.individual.net>
References: <XnsAD76816DCF4AFammammatatiscalineti@127.0.0.1>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net Jl6NQ0n22PnZmcu0z11DXwya6mANer8v4lWHj8WuoNe5oAFuP7
Cancel-Lock: sha1:YZnzWJ3bKBKc1zG6h0u8cxYJfnQ=
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
Thunderbird/78.12.0
In-Reply-To: <XnsAD76816DCF4AFammammatatiscalineti@127.0.0.1>
Content-Language: en-US-large

by: J.O. Aho - Thu, 29 Jul 2021 12:26 UTC

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

Maybe that is your account users PATH and not the system PATH. There is
a creepy GUI that you can use and check that.

> 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

You need to give the full path to the MSACCESS.EXE or see to that the
service user that runs the mssql has the correct path set in PATH. Don't
forget to restart the service after change in the environment variables.

>
> 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

Looks ok, as microsoft made a bad choise to use \ as directory divider
instead of /, so they couldn't escape characters as in most other
operating systems with the backslash.

> Any suggestion is welcome

Switch to a proper OS and a better database

//Aho

Subject	Author
MS SQL Server: run external program	Ammammata
Re: MS SQL Server: run external program	J.O. Aho