Solved

Using FLEX to access SQL 2005 Web Services

Posted on 2007-11-15
2
1,893 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now