Opening database from flash MX

Hello all,

We’ve designed a training course in macromedia Flash MX, and a test in Microsoft Access (MDB) (so that the test could reside on an intranet server. Shared Objects wouldn’t work because of this requirement). Anyway, I’m having trouble getting folks to open the database from Flash through an FScommand, and a getURL command works on some computers but not on others. If I could transform the database into an executable of some type, this could be readily opened by flash.

So here’s my question…

Any idea what I should do?

How difficult would it be to use director as a ‘wrapper’ so Microsoft Database Test (already designed) would open on any computer? What would be involved? I have Microsoft ODE tools 97, if that’s any help.

Any advice would be appreciated. We’re stuck on the 5 yard line for this project with everything else done, but we have no test, we’re in trouble. Thanks!

why go throught all that? Why not just use PHP to make the connection to your database?

Can I do that? My database is not connected to the internet in any way shape or form.

then no. you would probably need to use a compiled language like C,C++ or basic to access the database…

Flash is a “closed environment” and the only “exit” that I know is from LoadVars and XML variables.

You can’t access local ODBC from Flash. It’s like Javascript, while being more restrictive than this language.

I believe I read that if the database is on a “server” it should be accessible from an intranet via php … intranets are not nec. “local”… (?) …

Make a distinction between “local” and “server”.

In the programming world something local can be directly accessed (ie. a local variable).

In the case of Flash MX, you must use a server service to access a db.

Accordingly, you could have a webserver on your own machine (with PHP) and access your data from a local Flash application. - The webserver, the db and the flash application are local TO the computer.