Loading

Connection string to MS SQL database Android/IOS app

Connection string to MS SQL database Android/IOS app

Goran Bibic

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Goran Bibic2y ago
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.info,1433;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
Tahir Ansari2y ago
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.info,1433;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