flash data integration: SQL Server 2005 allows you to create native SOAP web services. I am trying to
access these using the webserviceconnector component but with no luck.

Have created SQL Server stored proc and ENDPOINT -

CREATE PROC dbo.SalesStoreProc
AS
SELECT
CustomerID,
Name
FROM
Sales.Store

CREATE ENDPOINT GetStores
STATE = STARTED
AS HTTP
(
PATH = '/Store',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = 'localhost'
)
FOR SOAP
(
WEBMETHOD 'StoreList'
(NAME='AdventureWorks.dbo.SalesStoreProc'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'AdventureWorks',
NAMESPACE = 'http://AdventureWorks/Store'
)
GO

After defining the webservice and adding a method the schema is defined with
params:Object and results:SqlResultStream (which is a datatype complex). When
triggering the webserviceconnector instance I get an error -

faultstring:"Unable to connect to endpoint: http://localhost:8800/Store"

I have read that this is a pretty common error and possibly associated with
complex data.

Has anyone tried using SQL Server 2005 Native SOAP and got this working? I
would think it would be a pretty common type of request.

Any help is appreciated.

Further information - the request sent to the webservice is as follows -

<SOAP-ENV:Envelope
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<StoreList xmlns="undefined" />
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

notice that no xmlns is defined. If I copy the request to XMLSpy I also get an
error. If I manually modify the soap request by putting in the namespace
http://AdventureWorks/Store instead of undefined I get a valid response back.

So why is flash not getting the default namespace? How can I set this? I can't
find any properties of the webserviceconnector that can be used for this. The
webservice definitely has this namespace information in the wsdl.

Help is appreciated. Cheers.

Further information - If the definition of the ENDPOINT is changed to specify
the namespace as "undefined" then the webservice request is successful.

Does anyone know how to set macromedia webservicecomponent to specify a
namespace other than undefined in the request?

Is no one else doing this? Google gives absolutely nothing for Flash with MS
SQL Server 2005 Native Web Services.

Well I have got this same problem, and also no Google help. I actually thought
it was authentication, because I cannot see the WSDL in firefox either. This
has helped a lot: at the moment I just need this for a demo, but I will have to
research further.

It look as though very few people have a broad enough knowledge of
technologies to even think of this approach! :D