1. Forum
  2. USENET
  3. comp.databases.mysql

  • MS SQL Server: run external program

    From Ammammata@ammammata@tiscalinet.it to comp.databases.mysql on Thu Jul 29 10:43:20 2021
    From Newsgroup: comp.databases.mysql

    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 ] ...........
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From J.O. Aho@user@example.net to comp.databases.mysql,comp.databases.ms-access,comp.databases.ms-sqlserver on Thu Jul 29 14:26:33 2021
    From Newsgroup: comp.databases.mysql


    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
    --- Synchronet 3.21d-Linux NewsLink 1.2