Android access to remote SQL database

by

This question has popped up several times. You PROBABLY can connect your android device to the SQL server directly if you deployed the MSSQL JDBC drivers to your android device and then exposed your SQL server directly to the internet. If the MSSQL drivers would work properly on Android is a completely different problem.

That is how you might be able to do it. However here is why that is a bad idea.

  1. You are exposing your SQL server directly to the internet. Unless you encrypt the data between your MSSQL server and android device it would be relatively easy for a determined hacker to sniff the TDS data stream between the device and MSSQL and reverse engineer it and steal your data. Encryption will probably make it much harder almost impossible for a attacker to steal your data. However an attacker could still launch a DOS/DDOS attack on your database directly. Not a good idea!

  2. If you are planning to connect other mobile devices (iPhone, Symbian, BlackBerry and so on) you will need to be able to create a SQL connection from those devices as well. iPhone does not support Java natively(from my memory) for example so you would need to find a way to connect iPhone to the SQL server. BlackBerry might be easier but Symbian you are going to be out of luck with. Thus you will need to almost create a custom solution for each device connecting to your database. Bad Idea LOADS of maintenance

Create a webservice or custom TCP/IP server which can manipulate your database. Connect to this webservice/service from your device. Webservices are the way to go. More than 90% of devices these days are natively capable of doing a webservice call.

More Related Contents:

  1. Connecting android with MS SQL SERVER 2008
  2. how to connect sql server using JTDS driver in Android
  3. Android Facebook style slide
  4. Crop image in android
  5. Not able to start Genymotion device
  6. Android : Loading an image from the Web with Asynctask
  7. Android AsyncTask threads limits?
  8. ViewPager with previous and next page boundaries
  9. Change Activity’s theme programmatically
  10. Android – drawable with rounded corners at the top only
  11. Android Custom Shape Button
  12. Theme/Style is not applied when inflater used with ApplicationContext
  13. How to get the current location in Google Maps Android API v2?
  14. Call from second sim
  15. get Context in non-Activity class [duplicate]
  16. Unable to import Eclipse project to Android Studio
  17. Getting “debuggable” value of androidManifest from code?
  18. Need to disable expand on CollapsingToolbarLayout for certain fragments
  19. Android – OnDateChangedListener – how do you set this?
  20. Recyclerview Changing Items During Scroll
  21. List all the files from all the folders in a single list
  22. Check if the SDCard is present, boolean is always true
  23. How do I set the rounded corner radius of a color drawable using xml?
  24. How do I detect a cancel click of the datepicker dialog?
  25. OnCreateView called multiple times / Working with ActionBar and Fragments
  26. How to display static google map on android imageview?
  27. How to add a SearchWidget to the ActionBar?
  28. Styling EditText view with shape drawable to look similar to new holographic theme for Android < 3.0
  29. How to use camera flash/led as torch on a Samsung Galaxy Tab?
  30. BLE scan is not working when screen is off on Android 8.1.0

Leave a Comment