Community-Credit.com | NonProfitWays.com | SOAPitstop.com   Skin:   
      User: Not logged in 
Home
Newsletter Signup
XSLT Library
Latest XML Blogs
Featured Examples
Presentations
Featured Articles
Book Chapters
Training Courses
Events
NewsGroups
 
Discussions
Examples
Tutorials
Tools
Articles
Resources
Websites
 
Sign In
My Profile
My Articles
My Examples
My Favorites
My Resources
Add a Resource
Logout
 
About Me
My Blog
HeadGeek Articles
Talking Portfolio
Resume
Pictures
World Trip Pics

Add this resource to your collection of Favorites...

Title:

XML and SQL 2000 (Part 3)

 

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).

 

URL:

http://databasejournal.com/features/mssql/article.php/2211161



 
 
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
DotNetSlackers
Buy text ads here!
Color Laser Printer
online business degree
Chanel sunglasses
Skype vs. sipcall
VoIP Internettelefonie
Buy text ads here!

Interested in Text ads?
2,219 Total Members
34 members(last 30 days)
7 members(last 7 days)
1 members(today)

1,609 Total Discussions
14 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

17,106 Total Blog Posts
1,791 Blogs(last 30 days)
273 Blogs(last 7 days)
44 Blogs(today)

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

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