Shiran Maor on Sun, 29 Apr 2012 19:48:20
I am new with azure.
I have database stored on my azure account.
I also have an Android application.
I want to connect to my azure DB from my android app (directly - not through webservice) - how can i do it?
Thank alot for all the helpers
Steve Marx on Sun, 29 Apr 2012 20:24:35
Just set the firewall rules for your database such that it can be accessed from any IP address. Then connect. It's just SQL.
But don't do this if you're ever going to distribute this app. Everyone who installed your app would necessarily have the credentials for your database.
Shiran Maor on Sun, 29 Apr 2012 21:02:36
First, thank you for answering.
Second, i am going to distribute my application, what do you suggest me to do?
Thank alot for your time
Arwind - MSFT on Mon, 30 Apr 2012 04:54:14
I think if you want to distribute your application, you need create a server application that "Listen" the requests from multiple clients, if they can provide correct credentials, the server application will access the SQL Azure Database and give response back to client, do not let clients application access the Azure DB directly, your SQL Azure Firewall only allow the server application IP address.
Hope this helps.