Hello. I receive an error when I launch my WebApp. All my tables were successfully converted to SQL and I am attempting to connect to a local SQL server using SQL Server authentication. As soon as I run my WebApp from DF I get an error message: "[Microsoft] [ODBC Driver 13 for SQL Server] [SQL Server] Login failed for user 'sa'. DataFlex Error #:4401 in line: 6371.
I am using SQL 2014 Develop Edition. My connection is successful when I set it up through the SQL Connection Manager but it fails at runtime. If I use Windows Authentication for my connection then everything is ok. I am double checked my password for the 'sa' account and verified that it has the necessary permissions.
Why would it reference "ODBC Driver" if I selected MSSQLDRV on the SQL Connection Manager?
I'm using Data Flex 19.0.33
Thanks for your help.