Tech Off Post

Single Post Permalink

View Thread: SQL XML support in IIS for 2005
  • User profile image
    mertsakarya

    Hi Darrell,

    As far as I know, in SQL 2005, they removed IIS support for SQL XML.
    The latest version that supports IIS is; SQLXML 3 SP 3. Actually I am using and loving IIS support of SQLXML on live systems. You can still use SQL XML 3.

    Anyway, I needed the same features with authentication of SQLXML and I created a similiar application with .Net 2.0 which requires Enterprise Library January 2006 edition. Currently I am testing it with XP SP2 machine and it is working out pretty well.

    My idea is to generate "Services" that contains "Atoms" (atomic actions, methods) on IIS, that way you can call sp with something like, http://www.domain.com/App/Services.Atom.ext?PRM1=1&PRM2=aa

    You can download the code (binaries, Web Application and source) at,
    http://workspaces.gotdotnet.com/MSServices
    or
    http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=1B979D9E-351A-49D4-8F4C-8D583C6BB396

    You need Enterprise Library January 2006 and Edition Visual Studio 2005 also IIS 5 or 6 and some Database connection. The configuration design is handled through Enterprise Libraries, Configuration Tool, the source uses many of the Application Blocks in Ent Lib.

    You have executors (Database SP executor, MSMQ Executor, Assembly Executor, IronPython Executor or .NetCode Executor), the results of the executors are returned to the clients through generators (WebService, RSS, JSON, Excel or Text). 

    If you want further discussion, you can contact me at mertsakarya@hotmail.com.

    Regards,
    Mert