problem while creating an ENDPOINT

Hi,

I am trying to create an ENDPOINT in SQL Server 2005 database. My script is as below. I am unable to create this endpoint. It shows error as 'Incorrect syntext near HTTP'

Script:

/****** Object: Endpoint [GetEmployees] Script Date: 03/02/2007 22:21:26 ******/
CREATE ENDPOINT [GetEmployeesBINA]
AUTHORIZATION [TIS-WORLD\Administrator]
STATE=STARTED
AS HTTP (PATH = http://tisserver:80/sql/shapeserv, PORTS = (CLEAR), AUTHENTICATION = (INTEGRATED), SITE=N'localhost', CLEAR_PORT = 80, COMPRESSION=DISABLED)
FOR SOAP (
WEBMETHOD 'EmployeeList'( NAME=N'[AdventureWorks].[dbo].[GetEmployees]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'AdventureWorks', NAMESPACE=N'http://AdventureWorks/Employee', SCHEMA=STANDARD, CHARACTER_SET=XML)

2) Once I create this endpoint. If I want to check the endpoint in browser , Which url I haeve to use.

Nilkanth Desai

You'd not included single quotes around the PATH, also the PATH was not in absolute format.

Try the code below instead.

Chris

CREATE ENDPOINT [GetEmployeesBINA]
AUTHORIZATION [TIS-WORLD\Administrator]
STATE = STARTED
AS HTTP (PATH = '/sql/shapeserv',

PORTS = (CLEAR),

AUTHENTICATION = (INTEGRATED),

SITE=N'localhost',

LEAR_PORT = 80,

COMPRESSION=DISABLED)

FOR SOAP (WEBMETHOD 'EmployeeList'( NAME=N'[AdventureWorks].[dbo].[GetEmployees]'

, SCHEMA=DEFAULT

, FORMAT=ALL_RESULTS),

BATCHES=DISABLED,

WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]',

SESSIONS=DISABLED,

SESSION_TIMEOUT=60,

DATABASE=N'AdventureWorks',

NAMESPACE=N'http://AdventureWorks/Employee',

SCHEMA=STANDARD,

CHARACTER_SET=XML)

|||

Hi Chris,

Thanks it works. But I am still facing problem while accessing it from client.As we use ASMX file in standard web services I can use url path of the ASMX file to get refference of the web service. But I do not know how can I get refference of WSDL & where it was generated?

Thank you,

Nilkangth

|||

Does this work?

http://Server/sql/shapeserve?wsdl

Chris

|||

Hi Chris,

This does not work. It is giving me error Page cannot be founf. TTP Error 404- File or Directory not found.

Server Name is TISSERVER.

SQL Server Name instance is DEVELOPMENT

Nilkanth Desai

|||

Hi Chris,

I have resoved this issue by taking web refference at http://localhost:8080/ShapeServ?wsdl . As I am publishing this webservice on 8080 port I am able to get refference in client.

Thanks for your Response,

Nilkanth Desai

Nilkanth Desai