Nilkanth


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




Re: problem while creating an ENDPOINT

Chris Howarth


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)







Re: problem while creating an ENDPOINT

Nilkanth

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






Re: problem while creating an ENDPOINT

Chris Howarth

Does this work

http://Server/sql/shapeserve wsdl

Chris






Re: problem while creating an ENDPOINT

Nilkanth

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

 





Re: problem while creating an ENDPOINT

Nilkanth

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