Solved

Using FLEX to access SQL 2005 Web Services

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

631 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