300 Chapter 7 " Building a SQLXML Web Service Application Introduction The main benefit of using SQLXML Web Services is that these services simplify the interaction between SQL, multiple platforms, and various languages including versions of Oledb (ADO), ODBC, JDBC, and so on. SQLXML Web Services help to better connect databases over an extranet, an intranet, or the Internet through the use of Active Server technologies.This enables multiple platforms to access the same services and attain the same results. In this chapter we will look at all the functionality that SQL Web Services can bring to our applications. One of the benefits of SQLXML Web Services is that they essentially cut out all use of Active Data Objects (ADO). By using a Web Service to complete our data interaction we can remove a level of complexity and thus remove a layer of potential errors, for instance,ADO recordset object errors. Like all database driven applications, you must always provide the back-end before designing and building the front-end application. By using SQLXML Web Services, deployment time is reduced consid- erably and resources are increased by virtually killing two birds with one stone. SQLXML Web Services also opens the back-end to multiple front-ends that may be built by third parties, with no additional development work. There are some added features that need to be installed before we can get started.The main thing is to have all the current service packs for SQL 2000 and Windows 2000 Server installed before going forward. In the overview we will cover how to install and configure the SQLXML Web Services Toolkit.To run the application we are going to build you must have Windows 2000 Server and SQL Server 2000 with the SQL Web Services Toolkit installed. Specifically, system requirements are: n Windows 2000 Professional n Windows 2000 Professional SP2 n SQL Server 2000 Developers Edition n SQLXML 3.0 n SQLXML Web Services Toolkit Using SQLXML Web Services is also a low-cost way to upgrade your current application (if it is not .NET) to a .NET platform. Instead of completely redoing the entire code base to upgrade the software to .NET there has been some inves- tigation into using SQL Web Services as a bridge to achieving .NET function- ality without dropping the whole project into the .NET sphere.This incremental migration strategy provides a low-cost and effective way to get an organization www.syngress.com