I am playing around with SQL Server 2005 Native XML Web Services; only I can't get them to work....
I've created a stored proc and tested it. It works fine.
CREATE
PROCEDURE [dbo].[GetVerizonProducts]
AS
BEGIN
-- Insert statements for procedure here
SELECT idProduct, description, details, price, imageURL, smallImageURL, sku, shortDetails from product
where idProduct in (161, 162)
END
I've created an endpoint.
CREATE
ENDPOINT VerizonProduct_Endpoint
STATE
= STARTED
AS
HTTP (
AUTHENTICATION = (INTEGRATED),
PATH = '/sql/vprod',
PORTS = (CLEAR)
)
FOR
SOAP (
WEBMETHOD
'http:\\tempuri.org'.'GetVerizonProducts'
(NAME = 'toughbook.dbo.GetVerizonProducts'),
BATCHES = ENABLED,
WSDL = DEFAULT
)
When I log onto the server and try to execute: http://localhost/sql/vprod
I get an empty HTML page. Any thoughts?
Jennifer