This is just to let you know that I've relatively recently implemented
a reasonably complete Web Service wrapper around the NS Subscription
API, resolving some gotchas along the way of course. Feel free to
email me at "mark dot weiss at moodys dot com" if you feel I may be
helpful in any way.
> Yes I am familar with how web services work, but just to keep the web
> servers clean the idea was to have the .Net 1.1 apps call to the SQL box for
> the API's that were wrapped as a web service. Since I have not been able to
> get SQL to register and assembly that I can expose as a UDF, which then
> could be exposed as an endpoint, we for now are resorting to installing IIS
> that will be the webservice. I really don't want to have to register the
> assembly in the GAC, but that seems like another way to get things done.
> We are trying to get our prototype up and going before the .Net 2.0 is
> release as gold code. We have a limited number of develop boxes, so we don't
> want to install beta software everywhere that may cause a complete rebuild
> when gold code is available. Once the gold code is available, then the web
> servers will have the NS API installed and they will make the calls that
> way. Our system will be physically separated, so the idea was to just have a
> WS on the NS box which is remote. Otherwise the API is making a remote call
> over firewalls etc, so we would probably be better served to use WS.
> This is all more than you really were looking for, but just thought I would
> lay it on the line. I guess we should pose some of this discussion to our
> TAP channels.
> "kate" <[email protected]> wrote in message
> news:[email protected]
> > >From our experience and what Shyam is saying you certainly dont need
> > IIS on the SQL box. If you create a webservice round the API elements
> > that you want and install that on your webserver, you can then call
> > than from the SQL 2005 assembly via a SOAP call without any need for
> > the NS or IIS elements to be present on the SQL box. This is how the
> > Reporting Services SOAP interface works and is very effective.
> > We have implented a similar strategy for SQL2000 and that works very
> > well with no need for the SQL box to have even heard of NS.
> > Kate MBCS
> > Alert Technologies
> > http://www.alert-technologies.co.uk
> > Get your notification services implementation going in minutes not
> > weeks ......