How to CREATE ENDPOINT
I am learnig to create a endpoint in Sql Server 2005. I have create a simple SP to get a customer in Northwind.
Then create a endpoint using HTTP.
SP:
CREATE PROCEDURE [db_accessadmin].[upGetCustomer]
@CustId nchar(5)
AS
SELECT CustomerID,CompanyName,ContactName,ContactTitle,Address,City,PostalCode,Country,Phone,Fax Then, create the ENDPOINT script,
FROM Customers
WHEREcustomerid=@custid
ORDER by CompanyName,CustomerID,Country DESC
USE [Northwind]
GO
CREATE ENDPOINT customer_endpoint I followed to .Net Sql Server 2005 shows and an article fro DevX website,http://www.devx.com/dbzone/Article/28525/1954?pf=true. Everything seems to be ok, i think but when I tried to check syntax/runs the script I gets error message, .Net SqlClient Data Provider: Incorrect syntax near ','. Thanks for advance.
STATE=STARTED
AS HTTP (
PATH='/sql',
AUTHENTICATION= (INTEGRATED),
PORTS = (CLEAR),
SITE = '*'
)
FOR SOAP (
WEBMETHOD 'http://tempUri.org','GetCustomerInfo'
(
NAME='Northwind.dbo.upGetCustomer', FORMAT=ROWSETS_ONLY,
schema=STANDARD
),
WSDL=DEFAULT,
BATCHES=ENABLED,
DATABASE='Northwind'
)
GO
This error is at close bracket before the FOR SOAP.
Can any1 help ..
Punpromk![]()

