December 20, 2000 01:20 PM

XML Updategrams

Rating: (0)
SQL Server Magazine
InstantDoc ID #16135
SQL Server 2000's new updategrams capability lets you use XML documents to update your databases
The new XML for SQL Web Release supports XML documents called updategrams, which let you use XML across HTTP to update your SQL Server 2000 databases. Updategrams contain special tags that work with SQL Server's IIS support to insert, update, and delete rows in a SQL Server table. Middle-tier agents such as Web applications and n-tier application components that post cha...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

This was a good article, but I'm wondering how this is done with parameters in .NET. I've been trying to do it, but so far I haven't had any success. The SQLXML Managed Classes are good, but the parameter class doesn't seem to want to work properly. I'm not sure if this has something to do with IIS or if it's SQLXML itself. I'd love to see an example of passing a parameter to an updategram with the .NET SQLXML Managed Classes.

Melissa2/1/2002 3:20:56 PM


For the insert and the delete everything is OK but when I try the update, I get an error message from OLE DB. Why ??? Anybody has experienced the same thing ??? Please help !!!

Alex Michaud 5/15/2001 1:57:12 PM


How will UPDATEGRAMS fit in with .NET? Installing .NET removes IIS. In the meantime, this is an excellent new feature that I will be implementing straight away.

James Speer 1/19/2001 2:14:29 AM


I think that this was a great article; this is something that I've been looking foward to. ADO support for updategrams is something else I am curious about. My concern is security. I suppose that I have to wonder if the IIS Virtual Directory Management for SQL Server tool settings is contained inside the(an) IIS Metabase? And how do these settings affect the ADO implementation--if there is a way to access ADO?

David Buchanan 12/20/2000 1:38:01 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS