Database Connectivity from Flash MX 2004

[sivaction]

Dear Friends,

I want to know how I can connect to a database like MS Access or SQL Server 2000 or any database using Flash MX. I want to retrieve data from database and view in Flash Applications. So how can I do this above issue.

Please reply me soon as this is very much urgent for me.

Thanks and Regards.
Siva.

[nick_kind]

Hi there,

Did you manage to get any info on your database question here?

I'm going to look into it too, so maybe I'l be able to help!

Cheers

NK

[freddycodes]

Web Services, Load Vars, Flash Remoting.

[prt1]

You cannot directly access a database from Flash as Flash is client based.
You need a server based language ie PHP or ASP.
As PHP and MYSQL database are free I would use them.
In general you write a PHP file (GETDATA.PHP) to get data from a MYSQL database.
You then get Flash to load the data using LoadVars with GETDATA.PHP as the parameter.
This is messy as you have to loop round the results in PHP and Flash.
Try using AMFPHP and Flash Remoting, this lets you retrieve loads of records and put straight into a RecordSet object in Flash.
The beauty of AMFPHP is that it lets you call a function in PHP as if it where in Flash.

[clp0978]

Try the following:
Macromedia Flash: Data From Flash Form to Access Database (http://www.experts-exchange.com/Web/WebDevSoftware/Flash/Q_20827372.html)Integrating Flash & ASP (http://www.asp101.com/articles/flash2/index.asp)
Flash MX 2004 Data Integration (http://www.macromedia.com/devnet/mx/flash/data_integration.html)

Hope that this can help you.
If you want to find out more tutorials/Articles about flash data integration try google. you will found a lot more.

brgds,
carlos pinho

[outlando]

Depending on your database size requirements, you could also use XML. This wouldn't require PHP or similar, you can just use the XML object. XML doesn't work for complex datasets though.

[tg]

Depending on your database size requirements, you could also use XML. This wouldn't require PHP or similar, you can just use the XML object. XML doesn't work for complex datasets though.


dude.

did you notice that these posts are like 2 years old?
i don't think they are waiting for the answer anymore.

[Coker]

try Flash SQL from www.netdrims.com (http://www.netdrims.com). You can run your SQL directly in FLash and get your recordset back into FLash.

[Flash Gordon]

-

[rajeshv]

Hi,

Try Flash Studio Pro it may solve ur problem..........

All the best !!!

Rajesh

[suneel_141.]

connectivity to mySQL with php