Wappler with Azure web app and sql database

Hi, I’m trying to set up a web app on azure.

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:

image.png552×607 18.5 KB

If I switch to the remote Azure hosted target the database connection won’t work:

azurenatve.PNG553×610 23.4 KB

azuresql.PNG553×605 18.3 KB

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!

Any one any ideas?

Thanks!