all groups > flash data integration > july 2006 >
You're in the

flash data integration

group:

Access Database with ASP


Access Database with ASP natg504
7/13/2006 3:20:12 PM
flash data integration: I'm new to using Flash with a database, but I need to set up a Flash
application that will access data in my MS Access database. I would be using
ASP, and I'm using Flash MX Pro. What would be the best way to do this? Are
there any good basic tutorials out there?

THanks,

Re: Access Database with ASP Motion Maker
7/13/2006 9:59:28 PM
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.



--
Lon Hosford
www.lonhosford.com
Flash, Actionscript and Flash Media Server examples:
http://flashexamples.hosfordusa.com
May many happy bits flow your way!
[quoted text, click to view]

Re: Access Database with ASP Goo101
7/18/2006 12:00:00 AM
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

AddThis Social Bookmark Button