none
Cannot access azure sql table from android by following quickstart guide RRS feed

All replies

  • Hi Abhigpcdnmi07,

    Thank you for bringing this to our attention. Are you using a Private DNS zone as part of this solution? Is this a production solution or are you working with a tutorial? If this is a tutorial, can yo provide a link to the documentation, as that will be helpful. There is currently an issue with the Private DNS service but wanted to get additional information from you in the case that this is not a Private DNS service issue.

    Thank you,

    Mike

    Friday, November 22, 2019 9:40 PM
    Moderator
  • Hi, 

    I guess, you are facing similar problem which is discussed in the below thread. Please let us know if that does not your issue.

    https://stackoverflow.com/questions/32954176/azure-mobileserviceinvalidoperation-exception-has-been-thrown


    -Malleswar

    Saturday, November 23, 2019 5:04 AM
  • I am not using Private DNS zones. Im working out a tutorial. the link for the tutorial is https://docs.microsoft.com/en-us/azure/app-service-mobile/app-service-mobile-android-get-started. Any help will be appreciated. Thanks in advance

    abhigpcdnmi07

    Wednesday, November 27, 2019 7:15 PM
  • I can reproduce this and the issue is that there is no means to create the ToDoItems table, or a means to create the appropriate database for the Quickstart to complete successfully. This affects all Quickstart and Tutorial documentation that rely upon this table schema to function properly.

    Azure SQL Database has an AdventureWorksLT sample database you can choose to deploy but it does not have an option to deploy a dataset called ToDoItems.

    I was specifically following the Create a Xamarin.Android App tutorial with .NET backend which does not implement Easy Tables.

    The Cosmos DB service has the ToDoItems database and I will convert that to a T-SQL script that you can use to complete the tutorial. I am also going to bring this to the attention of the product group.

    Regards,

    Mike

    Wednesday, November 27, 2019 11:00 PM
    Moderator
  • I believe you have created a ToDoItems Easy Table entry but the table does not exists in the Azure SQL Database instance the Easy Tables is connected to. There is a larger issue with all the Azure Mobile App tutorial variants where this table schema is needed. 

    Wednesday, November 27, 2019 11:14 PM
    Moderator
  • I skimmed the "Create a Xamarin.Android App" and thought I might try it until I hit

    Download the client SDK quickstarts for the following platforms:

    iOS (Objective-C)
    iOS (Swift)
    Android (Java)
    Xamarin.iOS
    Xamarin.Android
    Xamarin.Forms
    Cordova
    Windows (C#)

    Really? What is all this stuff and why do I need it just to make a connection?



    Mary

    Sunday, December 1, 2019 11:07 AM
  • Hi Mary,

    There should be a single T-SQL script available to each of the O/S specific tutorials to create the SQL schema for the tutorial to complete successfully. 

    In the case where there is an Easy Table implementation, there still needs to be a table schema to exist for Easy Table to sync with. I think that is the issue your case. Not all tutorials use Easy Tables. This is my observation. 

    If you were to create the table schema manually, I believe the tutorial would complete successfully. 

    Regards,

    Mike

    Monday, December 2, 2019 7:14 PM
    Moderator