Solved

Using FLEX to access SQL 2005 Web Services

Posted on 2007-11-15
2
1,902 Views
Last Modified: 2008-02-01
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
Comment
Question by:TNetworks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Accepted Solution

by:
Siva Prasanna Kumar earned 500 total points
ID: 20307977
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
 

Author Comment

by:TNetworks
ID: 20308783
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

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question