Groups > comp.databases.ms-sqlserver > #2098

Re: MS SQL Server: run external program

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver, comp.databases.ms-access
Subject	Re: MS SQL Server: run external program
Followup-To	comp.databases.ms-sqlserver
Date	2021-07-30 10:24 +0200
Organization	Erland Sommarskog
Message-ID	<XnsAD7769DEE4408Yazorman@127.0.0.1> (permalink)
References	<XnsAD76816DCF4AFammammatatiscalineti@127.0.0.1> <imfl3pFios7U1@mid.individual.net>

Cross-posted to 2 groups.

Followups directed to: comp.databases.ms-sqlserver

Show all headers | View raw

J.O. Aho (user@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.
> 
> 
>> 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

In *your* PATH variable. SQL Server runs under a service account, so 
it does not have your PATH.

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

So when you run that command line directly, what happens? Specifically, 
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.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: MS SQL Server: run external program "J.O. Aho" <user@example.net> - 2021-07-29 14:26 +0200
  Re: MS SQL Server: run external program Erland Sommarskog <esquel@sommarskog.se> - 2021-07-30 10:24 +0200
    Re: MS SQL Server: run external program Ammammata <ammammata@tiscalinet.it> - 2021-07-30 08:42 +0000

csiph-web