No matter what method I try, I am unable to connect to MySQL when server model is set to ASP.NET.
I am trying to connect to an AWS RDS MySQL instance.
I have a Windows 2012 server running IIS.
I have the project server model set to ASP.NET
I’ve tried Database Types of MySQL ODBC and ODBC System DSN.
I’ve tried on my Mac, using an FTP target, and then tried again by installing Wappler directly on the Web Server. I’ve also created both 64-bit and 32-bit versions of the system DSN.
I’ve also tried using ODBC driver versions from 3.5 to 5.3.
They all result in the same error as seen in the attached image.
“Error using this Database Connection! Server Response: Compilation Error”
Can you please advise?