473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Replacement for ISAPI in SQL Server 2005

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,

Oct 10 '06 #1
5 3192
Have you looked into HTTP Endpoints? Here's one article:
http://www.developer.com/db/article.php/3390241

"herman404" <he*******@hotmail.comwrote in message
news:11*********************@m7g2000cwm.googlegrou ps.com...
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,

Oct 10 '06 #2
Hello Mike C#,

In addition to HTTP Endpoints, note that the SQLXML 3.0 SP3 extension still
works with SQL Server 2005 on IIS5.2, IIS6 and with a little more effort
with IIS7.

Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
Oct 10 '06 #3
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,

Oct 11 '06 #4
Hello herman404,

This is why I advocating using the existing ISAPI filter. It continues to
work for SQL Server 2005 and since you have your infrastructure in place...
no brainer.

That said, if your service is returning XML, you should be able to call the
CreateReader method of it and bind that the the ASP.NET XML control. If,
instead, you are returning the result of a query as a DataSet, load that
into an XmlDataDocument and use one of its XML returning methods to bind
up to the control.

The best tutotial is the one you write for yourself.

Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
Oct 11 '06 #5
Hi everyone,

I have a stored procedure that outputs an transformed XHTML document as
an XML data type. I have an HTTP Endpoint that exposes this procedure.
What I want to know is how do I form the URL to access this XHTML
document directly. I have granted connect access to public and I have
tried this URL:

http://servername/EndpointPath?wdsl

But all I get in return is the following SOAP message at the end of
this post. Does anyone know if it is possible to directly access the
HTTP Endpoint's response by a browser, or am I going to have to write a
special client to consume it?

Thanks,

----------------------------------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="utf-8" ?>
- <SOAP-ENV:Envelope xml:space="preserve"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope"
xmlns:sql="http://schemas.microsoft.com/sqlserver/2004/SOAP"
xmlns:sqlsoaptypes="http://schemas.microsoft.com/sqlserver/2004/SOAP/types"
xmlns:sqlrowcount="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlRowCount"
xmlns:sqlmessage="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage"
xmlns:sqlresultstream="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlResultStream"
xmlns:sqltransaction="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlTransaction"
xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:wsdlgen="http://schemas.microsoft.com/sqlserver/2004/SOAP">
- <SOAP-ENV:Body>
- <SOAP-ENV:Fault
xmlns:sqlsoapfaultcode="http://schemas.microsoft.com/sqlserver/2004/SOAP/SqlSoapFaultCode">
- <SOAP-ENV:Code>
<SOAP-ENV:Value>SOAP-ENV:Receiver</SOAP-ENV:Value>
- <SOAP-ENV:Subcode>

<SOAP-ENV:Value>sqlsoapfaultcode:UnknownSqlServerError</SOAP-ENV:Value>

</SOAP-ENV:Subcode>
</SOAP-ENV:Code>
- <SOAP-ENV:Reason>
<SOAP-ENV:Text xml:lang="en-US">A server error occurred while
processing SOAP request: Receiver,
UnknownSqlServerError</SOAP-ENV:Text>
</SOAP-ENV:Reason>

<SOAP-ENV:Node>http://vdm44sql1:80/VegaRisk?wdsl?VegaRiskSVG</SOAP-ENV:Node>
<SOAP-ENV:Role>http://schemas.microsoft.com/sqlserver/2004/SOAP</SOAP-ENV:Role>

- <SOAP-ENV:Detail>
- <sqlresultstream:SqlMessage xsi:type="sqlmessage:SqlMessage">
<sqlmessage:Class>16</sqlmessage:Class>
<sqlmessage:LineNumber>25</sqlmessage:LineNumber>
<sqlmessage:Message>An unexpected query string was passed to a Web
Service Description Language (WSDL) generation
procedure.</sqlmessage:Message>
<sqlmessage:Number>17885</sqlmessage:Number>

<sqlmessage:Procedure>sp_http_generate_wsdl_defaul tcomplexorsimple</sqlmessage:Procedure>

<sqlmessage:Server>VDM44SQL1</sqlmessage:Server>
<sqlmessage:Source>Microsoft-SQL/9.0</sqlmessage:Source>
<sqlmessage:State>1</sqlmessage:State>
</sqlresultstream:SqlMessage>
</SOAP-ENV:Detail>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Oct 24 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Irene | last post by:
Hi, I have an asp page that allows a user to search for info in a DB and add info to a DB. The search uses "ADODB.Connection" objects in the page, but the add will use a call to an isapi dll...
6
by: msnews.microsoft.com | last post by:
I am a C# programmer with a little C++ experience from a few years ago. I need to write some ISAPI filters and extensions to run on the latest version of IIS on .net Server 2003. Can anyone...
3
by: Lionel Schiepers | last post by:
I rencently tested an web application with ISAPI extensions that internally use managed extensions but the call to the ISAPI failed. I receive the following message: "A dynamic link library (DLL)...
2
by: Jon Maz | last post by:
Hi All, I've been looking into options for URL Rewriting in .net, and to be honest, I haven't seen anything that's easier than the old Classic Asp solution with an ISAPI filter redirecting to an...
2
by: yachtIT | last post by:
HI MS, I have read from official microsoft msdn that an HTTPhandler in .NET can do anything a c++ isapi extension can do. Only a .NET HTTPhandler has a much more easy programming model. ...
1
by: Gregory Gadow | last post by:
Currently, my company's website uses a custom ISAPI filter to map a web user to a network user, and give the user access to our website. This has worked great for several years. We now want to add...
1
by: Samuel Shulman | last post by:
What is the difference between the 2 options for the installation of php
3
by: =?Utf-8?B?Um9kbmV5IFZpYW5h?= | last post by:
IIS 6 SQL Injection Sanitation ISAPI Wildcard at http://www.codeplex.com/IIS6SQLInjection I created an ISAPI dll application to prevent SQL Injection attempts by intercepting the HTTP requests...
2
by: M Bourgon | last post by:
Subject says it all, really. I want to start using Token Replacement, but do I break anything by enabling it? Do jobs that don't use tokens require any changes? I saw somewhere that it can't be...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.