Webmaster Forum / Flash / Data Integration / July 2006

If you know the ASP side for connecting to your database, you are almost
there. Otherwise, you face learning about how to use ASP, ADO and SQL to
work with Access databases on the web, as subject in and of itself
regardless if you are using Flash, AJAX or traditional web page data
requests and responses.

Your main decision will be the data structure protocol to use to send and
receive data between the Flash movie and the server script. You can choose
URL vars, the traditional web data structure or XML.

For URL Vars study the Flash Actionscript LoadVars class and in particular
the sendAndLoad method has a great example. ASP has all you need to get the
data from the Flash LoadVars sending object and return to a Flash LoadVars
receiving object.
See: http://livedocs.macromedia.com/flash/8/main/00002336.html

For XML study the Flash Actionscript XML class and again the sendAndLoad
method for this class has a great example. Here you need to know XML. Flash
does the XML parsing for you. On the server you need to learn an XML library
from Microsoft.
See: http://livedocs.macromedia.com/flash/8/main/00002879.html

Also with XML Flash Pro has UI Components that and an XMLConnector component
with binding to the UI components if that suits your style.

Try the following article, it covers eactly want you want to do using the same technologies. I found it very useful . . .

http://www.adobe.com/devnet/flash/articles/flashpro_asp.html