Plz i need help for Flex connectivity with database e.g Access using air.

Question

Hello all .... I need to connect my flex desktop application with different databases e.g access , mysql. I have done the connectivity with SQLite which is already embedded. I dont know how to use ODBC for example. And i dont need a php or asp bcoz i am not making a web application since i am using air i want to connect to DB locally. Thanks in advance

Answer 1

There is no direct Access, ODBC, nor MySql database connectivity in AIR.

You'll either need an itermediary to do that for you. For an all-local solution check out Merapi: http://www.merapiproject.net/ It lets you connect a java application to an AIR application. Since java has much of the DB connectivity you need, you could leverage some of that. This will likely not be a trivial undertaking and you'll lose some benefits of AIR (like the stellar distribution model they have).

Or you'll have to write a ton of AS3 code to directly access other database types at the database communication layer level. For MySql you'd probably use the socket classes and Access you'd likely use the local file classes. But that will be an absurdly high development time and is almost guaranteed not to be an acceptable answer for you. I haven't seen any projects working on these problems, but I wouldn't be surprised if one existed.