mysql - Connecting android with MS SQL SERVER 2008

Question

Is there a way that we can connect an Android application to a central database server (e.g. MSSQLServer 2008)?

I have a MySQL database that is accessed by both website and Android. Connecting to the database from the website is fine, but how can it be done from the Android app?

Answer 1

here are some similar questions asked (an answered):

• android MySQL connection
• How to connect to a MySQL Database from an Android App?

Even though those are for MySQL, it should work for MSSQL by changing the engine or the driver's use to connect. Usually, the approach is to expose some limited level of modification through a web service. Still, nothing is stopping you from directly accessing the database, albeit depending on the case, could pose a security risk.

Main Reasons the web service approach is taking:

• Performance
• Security
• Best Practice
• Separation of concerns

An exception is if you want to enable direct access because you're building a sort of database client through mobile.