Acceso directo a base de datos SQL desde APK de Xamarin

Sergi Mauri Also 1

Buenos días,
Tengo un aplicación realizada con Xamarin en la cual, desde el dispositivo mobil, accedo directamente a una base de datos SQL server ubicada en un DataCenter. No he desarrollado una API para el acceso a la base de datos, puesto que en este caso no me interesa y no es posible. Se trata de una aplicación muy sencilla.
En el dispositivo mobil tengo configurado un túnel VPN conectado con el servidor SQL server del DataCenter.
La aplicación funciona perfectamente en modo debug desde el dispositivo mobil, pero cuanto cambio a modo release no conecta con la base de datos.
Ahora mismo tengo desplegada la aplicación en modo debug en varios dispositivos, y funciona correctamente, pero lo optimo es implementarla en modo release mediante la APK para que sea mas eficiente.
Pueden por favor ayudarme a encontrar una solución al respecto.
Que es lo que impide el acceso a la base de datos en modo release? No me indica ningún error, simplemente no autentica y no conecta.
Esperando su ayuda al respecto, gracias y un saludo.

Olaf Helper 45,286 Reputation points

2021-01-18T09:05:47.99+00:00

This is an English spoken forum, so please post your question in English.
Leon Lu (Shanghai Wicresoft Co,.Ltd.) 77,181 Reputation points Microsoft Vendor

2021-01-18T09:40:14.923+00:00

When you generate the apk. please set Linker to None, then re-generate apk to make a test.
Sergi Mauri Also 1 Reputation point

2021-01-18T10:26:06.987+00:00

Thanks for your help
I have set Linker to None, then I have re-generated apk and it still cannot connect.
Sergi Mauri Also 1 Reputation point

2021-01-18T10:26:56.987+00:00

Good Morning,
I have an application made with Xamarin in which, from the mobile device, I directly access a SQL server database located in a DataCenter. I have not developed an API for access to the database, since in this case I am not interested and it is not possible. It is a very simple application.
In the mobile device I have configured a VPN tunnel connected to the SQL server of the DataCenter.
The application works perfectly in debug mode from the mobile device, but when I change to release mode it does not connect to the database.
Right now I have deployed the application in debug mode on several devices, and it works correctly, but the best thing is to implement it in release mode through the APK to make it more efficient.
Can you please help me find a solution about it.
What prevents access to the database in release mode? It does not indicate any error, it just does not authenticate and does not connect.
Waiting for your help in this regard, thanks and best regards.
Leon Lu (Shanghai Wicresoft Co,.Ltd.) 77,181 Reputation points Microsoft Vendor

2021-01-18T11:52:38.373+00:00

Please search your log in logcat If you faced the exception likeSystem.NotSupportedException CodePage 1254 not supported, try to add the internationalization assemblies. like this thread https://forums.xamarin.com/discussion/comment/100/#Comment_100
Sergi Mauri Also 1 Reputation point

2021-01-18T16:47:15.193+00:00

The APK does not indicate any errors, it just does not authenticate and does not connect.
In debug mode it works correctly.

Thanks for you help
Leon Lu (Shanghai Wicresoft Co,.Ltd.) 77,181 Reputation points Microsoft Vendor

2021-01-19T08:29:37.173+00:00

Please check your application, if it request the Internet permission.The most common cause of this issue is that the INTERNET permission is automatically included in a debug build, but must be set manually for a release build.

https://learn.microsoft.com/en-us/xamarin/android/troubleshooting/questions/android-internet

Sergi Mauri Also 1

Hello,
I already have the permissions activated in the project manifest, and it still cannot connect:

<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.ACCESS_WIFI_STATE" />
<uses-permission android:name="android.permission.BLUETOOTH" />
<uses-permission android:name="android.permission.CAMERA" />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.AUTHENTICATE_ACCOUNTS" />
<uses-permission android:name="android.permission.BIND_VPN_SERVICE" />
<uses-permission android:name="android.permission.USE_CREDENTIALS" />
<uses-permission android:name="android.permission.INTERNET" />

Thanks for your help.

Leon Lu (Shanghai Wicresoft Co,.Ltd.) 77,181 Reputation points Microsoft Vendor

2021-01-20T08:36:41.897+00:00

You can open a ticket(not free) for this issue. https://support.serviceshub.microsoft.com/supportforbusiness/onboarding?origin=%2Fsupportforbusiness%2Fcreate%3FsapId%3D211dd84f-3474-c3c5-79bf-66db630c92a6 Supportor will connect to your remotely.

Share via

Acceso directo a base de datos SQL desde APK de Xamarin

Your answer