Ms SQL database connection xamarin

Question

1.00/5 (1 vote)

See more:

, +

I have two online database for test mobile app
1) MYSQL (work from workbench and from xamarin app)
2) MS SQL (work from ssms, not work from app)

Both database are online and try to connect online from another network and mobile device

Error is:

System.InvalidOperationException: 'Internal connection fatal error.'

My code to my sql and work

protected override void OnAppearing()
        {
            base.OnAppearing();


            //MY SQL

            string connectionString = "Server=MYIPADRESS;Port=3306;Database=DatabaseName;Uid=admin;Pwd=password;";
            var koneksi = new MySqlConnection(connectionString);
            string queryString = " SELECT ime from drzave ";
            var cmd = new MySqlCommand(queryString, koneksi);

            koneksi.Open();
            var rd = cmd.ExecuteReader();
            users = new List<user>();
            while (rd.Read())
            {
                users.Add(new user
                {
                    Osoba = rd.IsDBNull(rd.GetOrdinal("ime")) ? string.Empty : rd.GetString(rd.GetOrdinal("ime")),
                }
                    );
            }
            rd.Close();
            listview_users.ItemsSource = users;
            koneksi.Close();
        }

Some help?

What I have tried:

C#

<pre> protected override void OnAppearing()
        {
            base.OnAppearing();
           
            string connectionString = "Data Source=MYIPADRESS,1433;Initial Catalog=DatabaseName;User ID=admin;Password=password;";

            string queryString = "SELECT ime FROM dbo.drzave";
            SqlConnection koneksi = new SqlConnection(connectionString);
            SqlCommand cmd = new SqlCommand(queryString, koneksi);

            koneksi.Open();
            var rd = cmd.ExecuteReader();
            users = new List<user>();
            while (rd.Read())
            {
                users.Add(new user
                {
                    Osoba = rd.IsDBNull(rd.GetOrdinal("ime")) ? string.Empty : rd.GetString(rd.GetOrdinal("ime")),
                }
                            );
            }
            rd.Close();
            listview_users.ItemsSource = users;
            koneksi.Close();

        }

Posted 19-Nov-23 20:32pm

Stylus STYLUS

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2023-11-20T03:50:00

You don't listen much, do you? As stated in your other copy of this same question, for a Xamarin app, you should NOT be connecting directly to a database engine. You SHOULD be calling a web service that sits in front of your SQL Server where the web service is doing the database work for you and returning results back to the client. Your Xamarin app should be calling the web service, not the database.

Your other copy of the question: Connection string to MS SQL database android/iOS app[^]

Next, a little pet peeve of mine. You do not have to specify the port number in the connection string unless your server is not using the standard port number, 1433.