Connection string to MS SQL database Android/IOS app

Question

I have problem with connection to database XAMARINE forms

ERROR IS:

System.InvalidOperationException: 'Internal connection fatal error.'

Normal C# windows form app work with this string

SSMS work normal with this credential

  string connectionString = "Data Source=sql.bss-solution.info,1433;Initial Catalog='ABC 2023';User ID=admin;Password=somepass;Connect Timeout=60";

Xamarine Forms have error

Maybe in database name have space ABC 2023, maybe need 'ABC 2023' or "ABC 2023" or [ABC 2023] (I try all solution not work)

Some help?

Thank you

Tahir Ansari · Answer

The error message System.InvalidOperationException: 'Internal connection fatal error.' can occur for a variety of reasons but in the context of Xamarin Forms it is often caused by a problem with the database connection string. string connectionString = Data Source=sql.bss-solution.info1433;Initial Catalog=[ABC 2023];User ID=admin;Password=somepass;Connect Timeout=60; Once you have updated the connection string try running your Xamarin Forms app again. If you are still getting the error

Goran Bibic · Answer

Without bracket error is The error message System.InvalidOperationException: 'Internal connection fatal error.' I am add brackets [ABC 2023] string connectionString = Data Source=sql.bss-solution.info1433;Initial Catalog=[ABC 2023];User ID=admin;Password=somepass;Connect Timeout=60; With this Error is: System.Data.SqlClient.SqlException: 'Cannot open database [ABC 123] requested by the login. The login failed. Login failed for user 'admin'. Cannot open database [ABC 123] requested by the login. The login failed. Login failed for user 'admin'.' With SSMS user and pass are ok. Test with windows form string is ok With Xamarin not work