On Mar 18, 2:37 am, uday kiran <[email protected]> wrote: - So for communicating database(On remote server) from our application - it is compulsory to write a driver like odbc???
No, ODBC (or JDBC) is at the wrong level. You do not want to be doing SQL over the network. Instead, you want to create a web server that does the SQL -- and you just ask it questions (via HTTP GET) or give it commands (PUT, POST, DELETE). If you already know Java well, a Java Servlet would be the easiest way to go -- running in a servlet engine line Tomcat. Tools like Ruby on Rails are supposed to make this even easier, but will involve learning a new language. You're going to have to go and do some studying, and look at a number of examples. I'm not going to look for a pointer to an example for you, because if you do it yourself, you can chose ones that more closely relate to what you're trying to do, or better fit your style of learning. But you can start on the server side by writing a unit test that simply takes a URL, interprets the parameters, and does the corresponding SQL query, and returns the result as either XML or JSON. Once you have that, it's a simple matter to embed that in the appropriate bit of code for your web server technology (e.g. a Servlet, in the case of Java). The client side just requests the data from that URL and reads it. Once you get that far for one kind of data, and the GET operation, the next steps will be both easier and more clear to you. Part of your problem right now is you're trying to deal with the entire question at once. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en To unsubscribe from this group, send email to android-developers+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
