Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Using FLEX to access SQL 2005 Web Services

Posted on 2007-11-15
2
Medium Priority
?
1,911 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 2000 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

926 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