Sage 100

 View Only
  • 1.  I need to call a VI job from MS Access. I tested

    Posted 01-10-2014 15:49
    I need to call a VI job from MS Access. I tested everything on my workstation and all when well. However, I run standard (Provided) on my workstation. I took the solution to the client and the VI script wouldn't execute. I set the IO setting to ON and found an error was being thrown when I called the VI routine on their workstation. My bad for not testing with the Premium versions rather than the Standard version. Anyway, the Sage 100 error message reads: ""SQL not enabled"" - That's it. No need to worry about TL DNR. Short and sweet. Anybody have any ideas?


  • 2.  RE: I need to call a VI job from MS Access. I tested

    Posted 01-10-2014 16:01
    Maybe that check box re From the Server (whatever it is - File on the Server? Something re Server)


  • 3.  RE: I need to call a VI job from MS Access. I tested

    Posted 01-10-2014 16:16
    I had issue calling a VI job using a SQL stored procedure. The issue turned out to be that SQL didn't recognize a mapped drive. Changed the call to a UNC path and that solved it.


  • 4.  RE: I need to call a VI job from MS Access. I tested

    Posted 01-13-2014 06:28
    @DougHiggs and @BethBowers, I will give both of these a try today and let you know what I find out. Thank you for your suggestions.