Flex & DB's??

[Juan_Jiménez]

Greetings, everyone. Let me introduce myself. My name is
Juan, aka ÐâŖк6. (You can call me DaRk6 or
just plain DaRk)



I'm a Flash Develper and I'm interested in lerning Flex. In
these days i´ll be buying my copy of Flex, and i want the
fullest version so I need someone to tell me which ony buy.



But that's not my issue, I really need to know if Flex can
connecto to any relational DB like MS SQL Server or MySQL,
directly, and if there is some componenet able to do it. I always
connected Flash to MySQL using PHP and XML, but watching some Flex
samples made me decide to start developing on it, and most of my
works are related with merchandising, so Flex's chart components
are just what I was looking for.

But I need to recieve dinamycal data and the company I'm
working for right now use MS SQL Server.



Thanks for spending some of your time reading me.

[Former Community Member]

In article <fgsp26$sfm$1@forums.macromedia.com>

"????6"<webforumsuser@macromedia.com> wrote:

> But that's not my issue, I really need to know if Flex
can connecto

> to any relational DB like MS SQL Server or MySQL,
directly, and if

> there is some componenet able to do it. I always
connected Flash to

> MySQL using PHP and XML, but watching some Flex samples
made me



You would use the same techniques with Flex.



--

Sean A Corfield -- (904) 302-SEAN

An Architect's View --
http://corfield.org/



"Perfection is the enemy of the good."

-- Gustave Flaubert, French realist novelist (1821-1880)

[Juan_Jiménez]

I was reading some tutorials and I got this 2 answers: You
have to use the Web Service technique, OR you build your own
connection to MS SQL Server:
http://www.cflex.net/showfiledetails.cfm?ChannelID=1&Object=File&objectID=571

Can someone check it and tell me if it is a solution?

[Juan_Jiménez]

I already found my answer, but now I really needo to ask you
people something else:

To connecto to MS SQL server i need to create a new instance
of a server connection, using a JDBC, BUT to configure it I need
JRun Management Console. I downloaded FDS from the Adobe site, but
I can't find the console :s

COULD ANYONE HELP ME?

[Juan_Jiménez]

Already instaled JRun 4 to use the JMC but now I´m
looking forward to create a MXML that fetches de data from the sql
server... any help?



NOBODY'S REALLY HELPING ME :(

[Juan_Jiménez · Accepted solution]

Already resolved my problem... thanks, I think... (that's
only in case you were looking forward to help me, and I doubt
it...)

[mrs_kariem]

Please Help me and Give me a solution. I am a bignner like
you and I need your help please.



Give me an example of how I can connect flex with DB (I want
to connect it with oracle). How I can do that??



please help meeeeeeeeeeeeeee

[Former Community Member]

You could write a JSP page that returned XML from HTTP posts
from your Flex

application using <mx:HTTPService>



Or, you could use LiveCycle DataServices and either write a
simple Java class

as a RemoteObject destination that queried your database
using JDBC.



Or, you could go further and using LCDS with it's
<mx:DataService> feature

and connect to a destination that makes use of either a
SQLAssembler or a

HibernateAssembler where it would manage all CRUD operations
to your DB table

and keep all connected clients in sync.



It all depends on what you're trying to do in your client
application.

[Juan_Jiménez]

I have already made apps that retrieve data from an external
server, using ColdFusion, but that option that Peter describes is
really interesting. Can you explain it to me? And if you can give
some sample code? I'll be eternally in doubt with you.

Thank You.