SData Install & Training

SUGGESTED

Has anyone here successfully installed SData and created an application that uses SData to write information into Sage 100 2013 (version 5.0) files?

I could not find any SData training on Sage University and I have found very few examples on the internet.  I did find one example on Chortek Technology Blog: http://blog.c-gconsulting.com/2013/04/sdata-with-sage-100-erp-2013.html

However, I'm unable to get the basic test URL to work: http://localhost/sdata/masapp/MasContract/ABX/$schema
I receive an error:
HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid.

Any help or guidance is greatly appreciated.

Thanks,
Danny


 


 

Parents Reply Children
  • 0 in reply to Dmitry

    We re-installed SData and still no luck. Still the same as before.

    Here are some screenshots.

    When we call sdata url (/sdata) via HTTPS we see folder listing and then if we open next level urls (/sdata/MasApp etc) we see file not found:

    If we call main sdata url (/sdata) or any next level url (/sdata/MasApp) with HTTP, then we see access denied error:

    In IIS management I see SData application pool working and I also see new website /SData:

    Can you pls help us? maybe we need to see for some specific settings?

    In Sage ERP I double-checked - "Enable Native SDATA adapter" is enabled and SData permissions assigned for support user.

    Thank you!

  • 0 in reply to Dmitry

    Have you tried actually connecting to a resource instead of trying to list directory contents?

    What happens if you use Internet Explorer and try the following?

    To get a speceific resource (table):

    https://machinename/sdata/MasApp/MasContract/companycode/tablename

        - Replace machinename, companycode and tablename with proper values

    Thank you,

    Kent

  • 0 in reply to Kent Mackall

    Yes, I tried 10-20 different urls from manual (schema, resource urls etc) too - it shows "file or directory not found" too. :-(

  • 0 in reply to Dmitry

    Hello everyone!

    One of tech guys said that it's probably because we use IIS7 and IIS6 compatibility were not installed prior to MAS installation.

    Could it be a reason?

  • 0 in reply to Dmitry

    Okay guys we fixed it!

    All that was required was to add two allowed items to ISAPI and CGI Restrictions, ASP.Net v2.0.50727 for both 32 and 64 bit. (See Screen Shot below.)