This content has been marked as final.
Show 6 replies
-
1. Re: Connect to a MS SQL Server database
atta707 Jun 11, 2008 4:09 AM (in response to phatnq2002)You can't!
Flex cannot *directly* connect to SQL Server or any other database for that matter.
You get data into flex using a HTTP layer: like for example using a ASP or ASP.NET page to generate XML -- or any other format of your choice JSON, CVS -- use HTTPService class, send a request to your server, get the data using result event of the class and do whatever you want to do wit this data.
Similarly, you'll need to post the data to the server over HTTP and store in the database.
There is no FDBC, like JDBC and ODBC!
ATTA -
2. Re: Connect to a MS SQL Server database
phatnq2002 Jun 11, 2008 7:41 PM (in response to atta707)Thanks atta707,
In accordance with you answer, we must export data from a table (or more) in SQL Server database to a XML data. It seems taking more time and hard to coding.
So, please tell me how to find a tool or a component that help me to do this.
Thanks again.
-
3. Re: Connect to a MS SQL Server database
atta707 Jun 11, 2008 8:37 PM (in response to phatnq2002)No. You don't have to.
Consider a ASP.NET page. It can connect to SQL Server using ODBC driver -- or whatever MS call the driver these days -- you run your query and get a result set. you process the result set and convert it to an XML string. Maybe using some library or built-in support for XML in .NET framework. Now you XML ready. Just write to the Response object of your page.
Have you made any Ajax calls for data in your project? If so, you already know how to get this data in Flex. Using HTTPService class instead of XMLHTTPRequest.
ATTA -
4. Re: Connect to a MS SQL Server database
phatnq2002 Jun 12, 2008 12:03 AM (in response to phatnq2002)atta707,
Can you send me a sample using an ASP.NET page to connect to SQL Server?
Sorry, disturb you more. -
5. Re: Connect to a MS SQL Server database
FlexPrashant Jun 12, 2008 5:07 AM (in response to phatnq2002)it's very simple you just need to give url in httpservices of your aspx page.......... Instead to using aspx page use webservice in asp.net ........ -
6. Re: Connect to a MS SQL Server database
apskang Oct 18, 2009 9:03 AM (in response to phatnq2002)Please checkout these two detailed blog entries (tutorials ) on Flex- SQL Server Connection.
Part1 - http://codeexpander.blogspot.com/2009/10/connecting-flex-to-sql-server.html
Part 2 - http://codeexpander.blogspot.com/2009/10/connecting-adobe-flex-to-sql-server.htmlHope this will help.
Thanks,
Amrit