Re: HTTP and SQLXML

From: Graeme Malcolm (graemem_cm_at_hotmail.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 11:53:29 +0100

The short answer is, yes - you can. However, a lot depends on what your
definition of "connect" is. If you mean opening an ADO / ADO.NET connection
as you would over a private network, then no - that won't work. If however
you want to expose your SQL Server through a Web Service interface, or you
just want to access specific queries through HTTP/S, then yes. Your best bet
is to download SQLXML 3.0
(http://www.microsoft.com/downloads/details.aspx?familyid=4c8033a9-cf10-4e22
-8004-477098a407ac&displaylang=en) and work through some of the examples
there.

Technically, what you're doing is creating an ISAPI application for IIS that
will connect to SQL Server on the requestor's behalf - to use HTTPS you'd
just need to install a certificate on the IIS server and configure the
virtual directory to require SSL.

Hope that helps,
Graeme 

-- 
----
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
www.microsoft.com/mspress/books/6137.asp
"Ralph Krausse" <gordingin@consiliumsoft.com> wrote in message
news:49eb6317.0405141028.6fa04e45@posting.google.com...
> I just learned about SQLXML, this is my senario and what I wish to do.
> My question... can I?
>
> I want a program of mine (behind firewall) to connect to my SQL
> database over the Internet using http(s). Can I use SQLXML for this?
> Or should I use XMLHTTP?
>
>
> Thanks
> Ralph Krausse
> www.consiliumsoft.com
> Use the START button? Then you need CSFastRunII...
> A new kind of application launcher integrated in the taskbar!
> ScreenShot - http://www.consiliumsoft.com/ScreenShot.jpg
Quantcast