Sage 100

 View Only
  • 1.  Custom Office Script ~ Script Control Object

    Posted 10-20-2022 21:52
    I just migrated a client from 2019 Advanced to 2022 SP2 Advanced. We also moved servers. 

    However, none of the custom office scripts are running on the new server.
    I am getting the following message when I check the syntax/ path on the new server.

    "The Script Control Object could not be created.
    Verify that you setup Windows Script to run Visual Basic or Java scripts in the Customizer module.
    For more information, refer to the Microsoft Download Center Web Site."

    I think something in the new server operating system is not configured, but  I can not seem to figure out what it is or where to look.
    Any ideas or thoughts would be appreciated.


    Thank you
    Michael

    # Custom Office #Scripting

     ​​

    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    ------------------------------


  • 2.  RE: Custom Office Script ~ Script Control Object

    Posted 10-21-2022 08:13
    Edited by Doug Higgs 10-21-2022 08:13
    This is a possibility.  Install Microsoft Windows Script Host
    On page 7, item 4 of the "Post-Installation Tasks" of the installation and System Administrator's Guide:


    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: Custom Office Script ~ Script Control Object

    Posted 10-21-2022 13:35
    @Michael Davis - See if the Windows Script Host is disabled. Here is the registry location: How to Enable Windows Script Host

    ------------------------------
    Alnoor Cassim
    ------------------------------



  • 4.  RE: Custom Office Script ~ Script Control Object

    Posted 10-21-2022 13:53

    Alnoor,

     

    Thanks for the suggestion. I did double check the registry and it is enabled (1).

     

    I also called, Sage, but they were no help and gave me the standard line of we can not help with custom office scripting. I am stuck at the moment, as no custom office scripts run. 

     

     

    Thank you

    Michael

     

     

    Michael  H . Davis

    CPA.CITP, MCSE

    Senior Consultant

    Michael.Davis@warrenaverett.com

    (D) 

    205.313.4734

    (O) 

    205.313.4700   

    (F) 

    205.592.9991

    2500 Acton Road, Birmingham, AL 35243

    Ranked as one of the top managed service providers (MSP)
    and managed security service providers (MSSP) 
    in the world several years in a row. 

     

     

     

    To contact our Software Support Team call 844.712.6223 or email software@warrenaverett.com.
    To contact our Technical Services Team call 888.419.9090 or email resource.center@warrenaverett.com

    Warren Averett is celebrating 50 years of serving our community and clients. 
    Learn more about our history and where we're going in the future. 

     






  • 5.  RE: Custom Office Script ~ Script Control Object

    Posted 10-21-2022 14:37
    If you double-click a .vbs file on the server does it open with a program like notepad?  It could simply be broken file associations.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 6.  RE: Custom Office Script ~ Script Control Object

    Posted 10-21-2022 14:40
    Is it possible IT is blocking it on the new server?

    Have you checked to see if the cscript.exe and wscript.exe programs exist under C:\Windows\System32 and C:\Windows\SysWOW64?

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 7.  RE: Custom Office Script ~ Script Control Object

    Posted 10-21-2022 14:56

    Cscript.exe and wscript.exe are in C:\Windows\System32 and C:\Windows\SysWOW64

     

    The file association are showing Microsoft Windows Based Script Host

     

    With it being a new server, IT actually does not have antivirus turn on it yet.

     

    It feels like it has to be something on this new server not being fully configured but I cannot seem to locate the issue or missing program.

     

    Thank you

    Michael

     

     

     

     

     

    Michael  H . Davis

    CPA.CITP, MCSE

    Senior Consultant

    Michael.Davis@warrenaverett.com

    (D) 

    205.313.4734

    (O) 

    205.313.4700   

    (F) 

    205.592.9991

    2500 Acton Road, Birmingham, AL 35243

    Ranked as one of the top managed service providers (MSP)
    and managed security service providers (MSSP) 
    in the world several years in a row. 

     

     

     

    To contact our Software Support Team call 844.712.6223 or email software@warrenaverett.com.
    To contact our Technical Services Team call 888.419.9090 or email resource.center@warrenaverett.com

    Warren Averett is celebrating 50 years of serving our community and clients. 
    Learn more about our history and where we're going in the future. 

     






  • 8.  RE: Custom Office Script ~ Script Control Object

    Posted 10-21-2022 15:05
    Create a simple file with the .vbs extension and just put MsgBox "Test" in it and try to execute it.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 9.  RE: Custom Office Script ~ Script Control Object

    Posted 10-27-2022 18:04

    Everyone,

    We finally got this resolved.

    It turns out that tcs*.dll file(s) was not properly registered.

     

    Found it after running the ..\sage\Common Components\RegCom64.bat file.

     

    Thank you

    Michael

     

     

    Michael  H . Davis

    CPA.CITP, MCSE

    Senior Consultant

    Michael.Davis@warrenaverett.com

    (D) 

    205.313.4734

    (O) 

    205.313.4700   

    (F) 

    205.592.9991

    2500 Acton Road, Birmingham, AL 35243

    Ranked as one of the top managed service providers (MSP)
    and managed security service providers (MSSP) 
    in the world several years in a row. 

     

     

     

    To contact our Software Support Team call 844.712.6223 or email software@warrenaverett.com.
    To contact our Technical Services Team call 888.419.9090 or email resource.center@warrenaverett.com

    Warren Averett is celebrating 50 years of serving our community and clients. 
    Learn more about our history and where we're going in the future.