Please don't do this. You really, really don't want to do this. I've written about this before -- it's the wrong way for a lot of reasons -- security, interoperability, performance, maintainability, upgradability, compatibility with firewalls...
What you want to do instead, is to build a web service, that exposes the proper functionality. I'd suggest a RESTful interface (google it; there are lots of examples and documents available), as it's more flexible and simpler than SOAP. You don't even want to expose your database server to the internet. It should be securely behind a firewall. And think about what happens when you want to change your database, and you have all these applications out there, expecting to be able to use specific SQL queries to get at the data. You cannot force users to upgrade. You can just break, of course -- but you'll lose a lot of customers, and a lot of them will tell other customers to stay away -- and they'd be right. Actually, I just saw the message that says you're using Sqllite. So you CAN'T even do it anyway, even if you wanted to. There is no network access to Sqllite. I'd saw sqllite isn't a good choice for a server application in any event. I'd suggest MySQL as an alternative. To quote the sqllite documentation: "On the other hand, a database engine that uses a server can provide better protection from bugs in the client application - stray pointers in a client cannot corrupt memory on the server. And because a server is a single persistent process, it is able to control database access with more precision, allowing for finer grain locking and better concurrency." On Mar 17, 6:32 am, uday kiran <[email protected]> wrote: > Hi folks, > > Im new bie to android.. i want to access external database from my > android application.. > I've searched so much time in the internet but could not get exact > idea how to implement?? > > Please help me If any one is having idea on that and post if u have > any code related to it... > > Thanks for the information in advance.. > > Cheers > Uday -- 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
