maui: Connecting to SqlServer errors

Description

I tried with a lot of different solutions but nothing seems working: the android emulator can’t connect sqlserver. Is there some bug that should be fixed? i’m loosing time?

Steps to Reproduce

string str = StringaConnessione(DB, Server);
                string qs = "SELECT * FROM dbo.Agenti;";
                using (SqlConnection connection = new SqlConnection(
                           str))
                {
                try
                {
                    connection.Open();

                }
                catch (Exception rt)
                {
                    string ff;
                    ff = rt.Message;
                }


                    SqlCommand command = new SqlCommand(qs, connection);
                
                    
                    command.ExecuteNonQuery();
                }

Link to public reproduction project repository

no public repository

Version with bug

6.0.486 (current)

Last version that worked well

Unknown/Other

Affected platforms

Android

Affected platform versions

Android from 29

Did you find any workaround?

Relevant log output

No response

About this issue

Original URL
State: closed
Created 2 years ago
Reactions: 1
Comments: 18 (3 by maintainers)

Most upvoted comments

@mamqua could you share the video? I am interested as well to see any help with this issue

Now we are working at sqlserver configuration and updates but when we will finish that job i’ll make a video. thx

mamqua on Sep 15, 2022

“It’s an issue with Android TLS/SSL provider which MAUI uses”

MAUI (This Repo) is a UI Framework for cross platform applications. MAUI (The UI Framework, this Repo) is built on top of MAUI (Or more specifically, .NET For Android), the .NET binding for Android.

Your issue is not something that can be fixed in this repo.

This issue should probably go to https://github.com/xamarin/xamarin-android or maybe https://github.com/dotnet/runtime, although it could be a root Android issue (Hence why it only happens on Android, and no other platform that MAUI (The UI Framework) supports, since those run on… other platforms…

@jonathanpeppers Would you have any ideas of where this should go? Should it stay here?

drasticactions on Oct 8, 2022

I doubt this is a MAUI (The UI Framework) issue, but another issue with your code. If you try to do the same thing in a net6 android app (dotnet new android) does it connect?

You probably don’t want to connect directly to a database through your app.

The code is really simple , it works if i use windowsmachine emulator but not with all android’s emulators or android device conneccted
i want connect directly to the database

mamqua on Sep 15, 2022