Yes, you can get xml data from a SQL-Server database directly through xPath url queries. The risk here though is that it opens up the possibility of SQL injection and isn't that secure. Your options are to create your own .Net web services or look into using a middle tier solution like WebOrb; for connectivity between a Flex client and a .Net backend.
-TH --- In flexcoders@yahoogroups.com, "Paul Andrews" <p...@...> wrote: > > ----- Original Message ----- > From: Tracy Spratt > To: flexcoders@yahoogroups.com > Sent: Sunday, April 05, 2009 5:01 AM > Subject: RE: [flexcoders] Flex, SharePoint and SQLServer > > > snip > > Flex can't really talk directly to a database. Supposedly, the later SQL Server versions support native http access. If that really works, scalably and securely, then you could use HTTPService in Flex to communicate with the db. I have not tried this, nor have I heard any success stories about that approach. > > > > You'd really have to handle that with care on anything but (perhaps) an intranet - a swf decompiler could expose your DB innards and security.. > > snip > > Tracy Spratt, > > Lariat Services, development services available > > > ------------------------------------------------------------------------\ ------ > > From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of Mic > Sent: Saturday, April 04, 2009 11:39 PM > To: flexcoders@yahoogroups.com > Subject: [flexcoders] Flex, SharePoint and SQLServer > > > > Just got introduced to the wonderful world of SharePoint recently, and am contemplating coding the client's BI application in Flex and then embedding into SharePoint. Are people doing this? All the data must come from SQLServer2005. Done some googling and understand that I could > > 1. Load data into SharePoint lists and then send to Flex > 2. Talk to 2005 directly from Flex. > > Is this correct and which is the better approach? > > Are there any examples of this kind of architecture? I did not really find much after a couple of hours of googling. > > I have looked at ASP.NET and VisualStudio etc and just feel I could do a better job with Flex. Don't want to infer Flex is superior, but I do know that I can write the app they need in Flex. Is this a sensible approach? Thanks in advance for any pointers, > > Mic. >