You can't take the data from AIR's sqlite db and update it on SQL server directly. You'd need a server side piece that understands the data coming in from the web service call (or flash remoting call) and build it into the form that SQL Server can understand.
Livecycle Data Services (a java based server side solution) http://www.adobe.com/products/livecycle/dataservices/ has built-in capability to sync between AIR's sqlite db and your server side database (though the data being sent to server is AMF format). Check out http://coenraets.org/blog/2008/05/insync-automatic-offline-data-synchronization-in-air-usi ng-lcds-26/ for more info on that.
Thanks for the reply.
Is it possible to use webservice with adobe air???
If yes then the data that I have to transfer from Air to sql server.
Where I have to use web service at?
At Sql Server side?
Or Adobe Air Side?
Yes, you can make webservice calls from AIR. You'd need to pick the data from your sqlite db that you want persisted and post it via a webservice call to your backend.
You need to have a server side backend that accepts web service calls, gets your data from the call and syncs the server side db.
The AIR piece can use mx:WebService to talk to this webservice.
Thanks for the reply.
So with Air I have to call my original Application's web service...
It would be great if you give me some examples or links based on this.
Check out http://www.adobe.com/devnet/flex/articles/restaurant_app_05.html
By the way, while you are searching for resources related to Flex / AIR online, this may be useful:
Just last thing I want to confirm is.
Can I connect SQL server from Adobe Air?
If that is possible that can solve some issues.
If it is possible then can you please suggest how would I can do that.
You can't connect to a SQL Server database directly (though if you write a actionscript library to do it, you could).
AIR apps are normally expected to talk to some server side backend code and not to databases directly (though it can, there's even a actionscript library that lets AIR talk to MySQL http://code.google.com/p/assql/ ).
Thinking logically the SQLite is the best backend companion for Adobe Air.
And Air also supports Sqlite.
If I am not wrong, Air has inbuilt class methods to connect with Sqlite.
I haven't been using Flex and I don't have any experience on it.
If you have any other alternative which are better then this, Please suggest.
anirudhs, big thanks
This is very simply using Flex, RemoteObject and some type of server side script (ColdFusion, ASP, PHP etc). I recently built a fully blown flex air app which connects to the SQL 2005 box directly via RO and CFCs. The data stream timing is amazing. I am currently working on syncing SQLLite and SQL 2005 via CFC.
If you follow these steps you can build almost any db driven air app with syncronization.
Flex RemoteObject --> CFC(if ColdFusion) --> RO_Hanlder (ArrayCollection) or sqlLite sync.
Here is an example:
<mx:method name="getAllCustomers" result="getAllCustomers_Handler(event)"/>
<cffunction name="getAllCustomers" access="remote" returntype="Query">
<cfargument name="searchterm" required="no" default="">
<cfquery name="data" datasource="datasource">