Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
herman404
Starting Member
10 Posts |
 Posted - 2006-10-10 : 10:20:14
|
| Hi everyone, I have some code that we need to migrate to SQL Server 2005 from 2000, and I have a webpage that upon viewing, fires a query to the SQL server using ISS and ISAPI. The result set is formatted for display using XSLT. But since ISAPI is deprecated in SQL 2005, I was wondering how to migrate this.Thanks, |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-10 : 12:53:32
|
| Have a look at HTTP endpoints instead. It's different because you can't just hit the URL like you do with ISAPI, you have to now make a web service call, but that shouldn't be a major change in your app.The alternative would be to write your own web pages that create the results that the SQLXML interface used to do, but that will probably be more work than having the app call the web services exposed by the HTTP endpoints. |
 |
|
|
herman404
Starting Member
10 Posts |
Posted - 2006-10-11 : 07:04:45
|
| Hi, thanks for the tip about endpoints. I've created an Endpoint that exposes the stored procedures I want to access; however the examples I've seen involve creating a standalone Windows app to consume the web service. Instead of that, I need to display the XML response as a web page using XSLT. Any links to a tutorial?Thanks, |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-11 : 10:10:42
|
| Any .NET application can consume the web service exposed by the HTTP endpoint, you've probably seen an example of a Windows app, but the steps to do that in a web application would be very similar.You basically do this1. Set a web reference to the web service exposed by the endpoint2. Call the method on the web service to get the XML3. Use an XslTransform to transform the XML with your XSLTHere are a couple of exampleshttp://www.15seconds.com/issue/020213.htmhttp://sqljunkies.com/Article/3A8519BA-5AC3-4561-9BA9-B132CD6DEB86.scuk |
|
|
|
|
|
|
|
|
Replacement for ISAPI in Sql Server 2005