O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Generating XML from SQL Queries

SQL Server allows you to access its data via a uniform resource locator (URL) over HTTP. The query looks like this:

http://YourServerName/CustomerData?sql=SELECT+*+FROM+Customers+FOR+XML+AUTO

NOTE

You must replace the reference to YourServerName with the name of your server.

Before you can run such a query, you must first set up Internet Information Server (IIS) to accept a URL.

Setting Up IIS for SQL Server

Several steps must be fastidiously followed before you can submit a URL request to SQL Server:

1.
Create a folder named Customers in your \Inetpub\wwwroot directory.
2.
Add two subdirectories, one called template and the other called schema.
3.
From the Windows Start menu, select Start, Programs, SQL Server, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required