`I’m developing a Flutter app for both Android and iOS. I’m using the mssql_connection library to connect to my SQL Server database, which has a public IP. The library works fine on Android, but when testing on iOS, the mssql_connection library doesn’t work as expected.
I tried creating an intermediary app using Flask to manage the connection, but this approach assigns a local IP to the Flask app, which isn’t suitable for my needs as I want to avoid using an intermediary app.
How can I make the mssql_connection library work on iOS, or is there an alternative way to connect directly to my SQL Server from the iOS version of my Flutter app without using an intermediary service?
I have tried the following:
Tested the mssql_connection library on Android, and it worked perfectly, connecting directly to my SQL Server database with a public IP.
Attempted to use the same library on iOS, but it failed to establish a connection.
Created an intermediary app using Flask to manage the database connection, but the app assigned a local IP, which is not suitable for my needs as I want to avoid using an intermediary service.
I expected the mssql_connection library to work on iOS as it does on Android, allowing direct communication with the SQL Server. However, the connection did not work on iOS, and using an intermediary app with a local IP is not a viable solution for my case.`
David Herrera is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.