| |   Skin:   
      User: Not logged in 
Newsletter Signup
XSLT Library
Latest XML Blogs
Featured Examples
Featured Articles
Book Chapters
Training Courses
Sign In
My Profile
My Articles
My Examples
My Favorites
My Resources
Add a Resource
About Me
My Blog
HeadGeek Articles
Talking Portfolio
World Trip Pics

Resource Name:

XML and SQL 2000 (Part 3)

Resource Description

In the third article of this series, we will look into executing T-SQL statements against SQL Server 2000 via HTTP. This functionality is provided by SQLXML component (implemented in the form of SQLISAPI.DLL, which is included as part of SQL Server 2000 installation). The updated versions of this component are available as a separate download from the Microsoft Web Site. By installing this component on the web server, you will be able to associate its virtual directories with individual databases on the SQL server. This allows users to access the databases by using the http://webserver/virtualdirectory path, where webserver is an IP address or name of the Web server and virtualdirectory is the name assigned to the virtual directory. The management of these virtual directories is handled with the IIS Virtual Directory Management for SQL Server tool (for SQLXML version included with SQL Server 2000) or with the Configure IIS Support tool (for downloadable SQLXML 2.0 and 3.0 versions).

Resource URL:

Rating: 0
# Times Viewed: 931

Fans of "The Office"
Dwight Bobbleheads are here!
  “It's me! I'm the bobblehead! Yes!”

Advertise on XMLPitstop

Advertise on XMLPitstop

EggHead Cafe
Web Servicee development
fax to email
clown masks
internet fax
Distribuidores Alojamiento Web
Web Hosting
Printer ink
VoIP Internettelefonie AT
Color Laser Printer
Shopping Cart
IP Network Security Cameras

2,503 Total Members
40 members(last 30 days)
10 members(last 7 days)
0 members(today)

1,729 Total Discussions
10 Posts(last 30 days)
2 Posts(last 7 days)
0 Posts(today)

33,451 Total Blog Posts
2,370 Blogs(last 30 days)
583 Blogs(last 7 days)
55 Blogs(today)

8,699 Newsgroup Posts
0 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

13,835 Total Resources
7 Resources(last 30 days)
1 Resources(last 7 days)
0 Resources(today)