Connecting to a database

suddethm · 08-28-2002, 11:38 AM

The only tutorials I can find on Flash 5 and databases involve mySQL. Can you used Flash 5 to connect to Microsoft SQL databases? If so, can you point me to a tutorial?

Also, does Flash connect directly to a db to do queries, or do I need to create txt files of the data and pull those txt files into my Flash file.

Thanks in advance!
Michelle

**catbert303** · 08-28-2002, 12:25 PM

You should be able to connect flash with any database, you need some kind of server side scripting language to link between the database and flash (mySQL is commonly used with PHP a with a microsoft databse you're likely to use ASP) the process works by flash sending variables from the movie to an ASP script, this ASP script can maybe do some kind of processing and then insert data into the db. To retrieve data again you use the loadVariables action to call an ASP script this script can query the database to find the desired information and then send the variables to flash where they can be displayed.

Hopefully this link will help http://www.asp101.com/articles/flash/index.asp

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

08-28-2002, 11:38 AM	#1
suddethm Member Join Date: Jan 2001 Posts: 68	The only tutorials I can find on Flash 5 and databases involve mySQL. Can you used Flash 5 to connect to Microsoft SQL databases? If so, can you point me to a tutorial? Also, does Flash connect directly to a db to do queries, or do I need to create txt files of the data and pull those txt files into my Flash file. Thanks in advance! Michelle

08-28-2002, 12:25 PM	#2
catbert303 Moderator Join Date: Aug 2001 Location: uk Posts: 11,221	You should be able to connect flash with any database, you need some kind of server side scripting language to link between the database and flash (mySQL is commonly used with PHP a with a microsoft databse you're likely to use ASP) the process works by flash sending variables from the movie to an ASP script, this ASP script can maybe do some kind of processing and then insert data into the db. To retrieve data again you use the loadVariables action to call an ASP script this script can query the database to find the desired information and then send the variables to flash where they can be displayed. Hopefully this link will help http://www.asp101.com/articles/flash/index.asp