• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1916
  • Last Modified:

Using FLEX to access SQL 2005 Web Services

Hello, I have the following problem.  I have created an endpoint in SQL 2005 and am trying to access it in FLEX.  The syntax for the web service in FLEX is as follows:

 <mx:WebService id="wsBlogAggr"
        wsdl="http://localhost/Store?wsdl"
        useProxy="false">
        <mx:operation name="StoreList"/>
    </mx:WebService>

The ENDPOINT in SQL is configured and I can use the SOAP option in XMLSpy to query it and return the result set.  FLEX returns the error:

[WSDLError faultString="Element http://AdventureWorks/Store:StoreListResponse not resolvable" faultCode="WSDL.BadElement" faultDetail="null"]   etc...

So, does anyone have any successful examples on how to set up an SQL ENDPOINT in MS-SQL 2005 and configure a WebService in FLEX so it functions?

Many thanks








0
TNetworks
Asked:
TNetworks
1 Solution
 
Siva Prasanna KumarPrincipal Solutions ArchitectCommented:
Here is a short cut method,

Use Flex 3 Beta to generate the web services stubs and use them this will solve the problem.

The actual problem above is that flex is not able to resolve one of the specified XML element can you show me that WSDL?
0
 
TNetworksAuthor Commented:
Thank you for that. I was able to solve it on your advice - by using Flex Beta 3 - and the updating my install with Flex SDK HotFix 3.  Apparently they revamped the WebServices support and now it functions as one would expect.  

Thanks a lot.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now