This content has been marked as final. Show 4 replies
The SQLConnection is intended for a local embedded database and can’t be used for anything external to Apollo. You don't need to install any specific driver to use the embedded database.
What could it be the wizard to create connections that exists in the Builder 3.0
Thanks in advance
The Data Wizard in Flex Builder 3 is a new feature that helps you get up & running fast when working with a server. The wizard will generate Flex code for your client side and PHP or Java code for your server side, giving you a simple "scaffolding" app to build on top of.
The DB connection info is needed so that the wizard can introspect your DB tables and generate the appropriate code. I believe the connection info also finds its way into the generated PHP or Java.
Bear in mind that an architecture where your client directly talks to a remote SQL server often has serious security risks. Using a three-tiered approach where the client's requests pass throuh a server layer, like what the Data Wizard generates, is usually the preferred way to go.
Hi. Just to clarify, AIR apps can work with SQL Server or any database for that matter using the same techniques you would for any Flex app. That is, write the database queries using the server technology of your choice and expose them as an RPC service that your AIR app can access. LiveCycle Data Services 2.5 has a great feature for this, the SQL Assembler. Or you could use ColdFusion, PHP, ASP.NET, custom Java, or anything that can spit out a web service or even just XML over HTTP. As Peter notes, Flex Builder 3 has a new feature for helping you generate this with a PHP or Java backend, and there are also separate ColdFusion extensions for Flex Builder that help you do the same with CF.