RE: [flexcoders] Re: Connecting to a sql or an access database through flex

[Tracy Spratt]

I recommend HTTPService.  Web services are unnecessarily complicated if you have control of both client and server.  To use HTTPService, just create an aspx application with the content-type =”text/xml”.  Then use the .net data access objects to talk to the database, and return XML to the calling Flex client.  If your data requirements are simple enough, use FOR XML [raw, auto, explicit] in the SQL queries, and you won’t even need to massage the data into xml.   Set resultType=”e4x” in the HTTPService tag.   I would post an example, but my current exampl is so old, it uses Flex 1.5, and classic ASP.  I am using .net in production, but haven’t created an example yet.   Tracy   From: flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of Tim Hoff Sent: Tuesday, June 06, 2006 11:01 AM To: flexcoders@yahoogroups.com Subject: [flexcoders] Re: Connecting to a sql or an access database through flex   Hi Rama, Getting SQL Server or Access data into Flex isn't that difficult.  However, it's not that easy either.  There are currently several different technologies that you can use to get .NET data into Flex. They include: Web Services, HTTPService, Flash Remoting, WebOrb and Fluorine.  In addition, the Flex RPC components may be combined with Flex Data Services (FDS) to provide integrated enterprise functionality. My guess is that all of this is too much information.  You probably just want to connect Flex to a SQL or Access database, right?   Well, to get your feet wet, I would recommend reading the following two articles/examples.  They are not current with F2B3, but little change is required. Andrew Stepford's Weblog - Flex and .NET web services pt1.  Andrew Stepford's Weblog - Flex and .NET web services pt2.  Using .NET web services to get data into Flex is probably the easiest approach to learn.  However, it's also the slowest data transfer method.  I'm not recommending that you choose web services for your data needs.  But, for learning purposes, you should be able to get up-to-speed, in a short amount of time.  At the same time, I would start reading the Flex Help Documentation.  It contains just about everything that you might need to know about "Working with Data."  Once you have a data connection, you can look into the other technologies to determine which approach is right for your application. Best Regards, Tim Hoff --- In flexcoders@yahoogroups.com, "rama satoskar" <[EMAIL PROTECTED]> wrote: > > Hi all, > Can anyone teach a way to connect the flex application to an access > database or sql database.What i need is a simple tutorial or a sample > example. > Kindly help. > Thanks in advance. > > Rama. > __._,_.___ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com SPONSORED LINKS Web site design development Computer software development Software design and development Macromedia flex Software development best practice YAHOO! GROUPS LINKS  Visit your group "flexcoders" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. __,_._,___