I use quite a bit of ASP, ADO and SQL for my websites, to link an Access
database to the webpage.

My question is, can Flash connect to an access database to read and write data.

From what I understand I need to use a dataset to hold the data then a
RDBMResolver to convert the data into something meaningful in SQL for the
access database.

But then I read I might need Coldfusion as well?? Which I will confess I have
not used before.

So i'm a little confused. If anyone can make this a little clearer, I would
be most grateful.

Peter M

"Peter Mayhew" <webforumsuser@macromedia.com> schrieb im Newsbeitrag
news:cb7qs4$abo$1@forums.macromedia.com...
[quoted text, click to view]


Some basics:

If you want to connect to a Access DB via ASP you have to define an ODBC
connection (a DSN or a Connection String). Then Internet Information Server
can connect to the DB by using the build in ADO objects. Try to search the
IIS help oder http://msdn.microsoft.com/library for details.

You than write an ASP script which connects to the ODBC connection reads out
some specific SQL querys and writes the information to the file:

----ASP Code for connecting to DB and doing query stuff----

My_Variable = myADO.Fields.Item("table_field").Value

Response.Write(My_Variable)


Than you have to call the asp-file fromw ithin the flash movie (i guess via
the "loadVariables" Command, but I'm not sure. consult action script
dictionary), and load "My_Variable". That's it.
You should be carefull --- loading external variables out of an database is
asynchronous. so you have to check for the data being loaded befor you use
the date in your movie.

Kind regards
Johannes

---------------------------
http://alphaeus.at ---- the coolest agency on earth!