HTTP ENDPOINTS

Question

HTTP ENDPOINTS

A Bheja

Newbie

Points: 3
More actions
February 7, 2007 at 1:50 pm

#194231

Hello
I'm fairly new to SQL and in trying to move from SQL 2000 to 2005, I need to work with the HTTP ENDPOINTS.
When I create an ENDPOINT, how am I supposed to retrieve the data? After creating a simple stored procedure with a select statement and creating an ENDPOINT, I cannot retrieve the data from the browser?
In this example below, I use http://localhost/site?wsdl but get a page with a lot of XML but not data?
Any help is appreciated.
Thanks.
----
CREATE ENDPOINT ENDPOINTTEST
STATE = STARTED
AS HTTP
(
SITE = 'localhost',
PATH = '/site',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR)
)
FOR SOAP
(
WEBMETHOD 'Test'
(
NAME = 'xDatabase.dbo.Store_Procedure',
SCHEMA = STANDARD
),
WSDL = DEFAULT,
BATCHES = ENABLED,
DATABASE = 'xDatabase'
)
------

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

A Bheja Newbie Points: 3 More actions · Answer 1

The Network Admin who was here before had written a perl script that utilized the IIS Virtual Directory in SQL 2000. All I want to do is move on to the new server with SQL 2005.

Thanks again.

A Bheja Newbie Points: 3 More actions · Answer 2

http://localhost/site?wsdl produces no result on the browser.

What am I doing wrong?

Thanks.