Hi,

I m an asp developper and i m searching the best way to communicate between
access and flash ( access database).
What do you think is the best way to do it? ( By Flash 8 Pro)

Is there any tutorial ( simple one)?

Thanks a lot.

L Stephan Brest France

What do you think is the best way to do it? ( By Flash 8 Pro)

Flash 8 has nothing to do with accessing a database. It does have the
ability to communicate with server side script that in turn deals with the
database. The decision is more about server side technology.

You most likely will be looking at ASP or ASP.Net for communication with
Flash where an Access database is involved.

Then ASP or ASP.Net will respectively use ADO or ADO.Net most likely to
communicate with an Access database on web server.

Flash can communicate with the ASP and ASP.Net or any server side scripting
many ways depending on the data format. For URL vars, the LoadVars AS
(Actionscript) class is used and for XML the AS XML class is used. There are
more variations on the XML approach with Flash 8 professional components and
XMLSocket AS class.

The server script gets requests from Flash via LoadVars or XML objects and
the server script uses middleware like ADO to get deal with the database and
return messages back to Flash again through LoadVars or XML class objects.

You might want to gander at this echo hello world example I use in Flash
seminars to layout the principles of communication with ASP using XML but it
does not show database access:

http://www.hosfordusa.com/ClickSystems/courses/flash/examples/XMLASP/Ex01/XMLASPEchoEx01_Doc.php



--
Lon Hosford
www.lonhosford.com
May many happy bits flow your way!
[quoted text, click to view]
Hi,

I m an asp developper and i m searching the best way to communicate between
access and flash ( access database).
What do you think is the best way to do it? ( By Flash 8 Pro)

Is there any tutorial ( simple one)?

Thanks a lot.

L Stephan Brest France

Forgot to mention ColdFusion. This would replace the ASP ADO part and do the
serverside work.

All are good ways. Many of the decisions are based on skill sets.

--
Lon Hosford
www.lonhosford.com
May many happy bits flow your way!
[quoted text, click to view]
What do you think is the best way to do it? ( By Flash 8 Pro)

Flash 8 has nothing to do with accessing a database. It does have the
ability to communicate with server side script that in turn deals with the
database. The decision is more about server side technology.

You most likely will be looking at ASP or ASP.Net for communication with
Flash where an Access database is involved.

Then ASP or ASP.Net will respectively use ADO or ADO.Net most likely to
communicate with an Access database on web server.

Flash can communicate with the ASP and ASP.Net or any server side scripting
many ways depending on the data format. For URL vars, the LoadVars AS
(Actionscript) class is used and for XML the AS XML class is used. There are
more variations on the XML approach with Flash 8 professional components and
XMLSocket AS class.

The server script gets requests from Flash via LoadVars or XML objects and
the server script uses middleware like ADO to get deal with the database and
return messages back to Flash again through LoadVars or XML class objects.

You might want to gander at this echo hello world example I use in Flash
seminars to layout the principles of communication with ASP using XML but it
does not show database access:

http://www.hosfordusa.com/ClickSystems/courses/flash/examples/XMLASP/Ex01/XMLASPEchoEx01_Doc.php



--
Lon Hosford
www.lonhosford.com
May many happy bits flow your way!
[quoted text, click to view]
Hi,

I m an asp developper and i m searching the best way to communicate between
access and flash ( access database).
What do you think is the best way to do it? ( By Flash 8 Pro)

Is there any tutorial ( simple one)?

Thanks a lot.

L Stephan Brest France

Bonjour,

An article in DevNet by Phil Heinz:
Flash MX Professional 2004 Data Integration
Using Microsoft Active Server Pages (ASP)
http://www.macromedia.com/devnet/flash/articles/flashpro_asp.html

Two examples (articles in French. See the readme.txt
for english version)

Sample application in ASP with Access or SQL-Server
(with XML and updatePacket technique):
http://www.philflash.inway.fr/contactasp

Time Entry application in ASP with Access or SQL-Server:
http://www.philflash.inway.fr/timeasp

For your information, the same examples are avalaible
with PHP (PHP5 for XML) and MySQL:

Sample application in PHP (PHP version 5) with MySQL,
XML and updatePacket technique:
http://www.philflash.inway.fr/contactphp

Time Entry application in PHP (PHP version 5) with MySQL:
http://www.philflash.inway.fr/timephp

And if you have problems of performance with XML,
see this article:
DataGrid Performance (or how to read 2 000 records of XML
in less than 0,5 second).
http://philflash.inway.fr/dgperf/

Philippe
http://philflash.inway.fr

Thanks a lot to everyone for your informations.

L Stephan



"Philippe Nomail" <webforumsuser@macromedia.com> a écrit dans le message de
news: dqkrt1$hm8$1@forums.macromedia.com...
[quoted text, click to view]