I have both a local and remote (Azure Web App) target in my Wappler project. Both are working and I can publish files to Azure via FTP. Where there’s no database connection Azure is working OK.
I can connect the local setup to an Azure SQL database using the SQL Server Native connection:
I can’t add an ODBC driver to the Azure Web App as they’re locked down, so I’m at a bit of a loss as to what to try. There are a few similar posts around Azure and Wappler but I can’t find any that seem to come to a positive conclusion!
I am having the exact same issue, I have a large post written up about it, but this is essentially the issue that is holding me back.
@sbecks Have you found a solution or work around to this yet? Is your app PHP based? As in do you have PHP selected in the project settings as the server model?
Does Wappler only use ODBC for database connections?
I have been trying to work around this for the last week to no avail. I was wondering if we could use the connection strings in the Azure sqlserver to manually create a database connection file, so that we can use all the rest of the Wappler functionality.
I would just really like to know if this is a limitation in Wappler or if there is a possible workaround.
