Run query against SQL Server

[DanNorman]

Hi all, has anyone here on the forum spent any time setting up a widget that can run queries (insert, update, delete) against a sql server database table that is not stored in an ArcGIS server database?

We would like to know whether it is as simple as having the correct database connection string and credentials and passing a query... or whether it is much more involved.

This doesn't necessarily matter but the table would be set up for Tempest land management software.

Thanks!

[RobertScheitlin__GISP · Accepted solution]

Dan,

  This is not something that can be done using clientside technology like JS. You would have to have a web service on the server that has access to the enterprise database. As a .Net developer I have created RESTfull .net web services to read enterprise databases all the time but I have never had the need to write to them. Either way this is no elementary task.

[DanNorman]

Thank you very much for the reply Robert, that does answer my question.

I wont blame the messenger for the bad news!

Thanks!