I am struggling to connect to SQL using ODBC even to connect directly to SQL without using ODBC.
I have tried connecting directly to SQL and connecting using ODBC.
Look at the picture below I tried to go to Admin on airflow to connect SQL and Airflow:
I created a demo database on SQL, login as Demo and password as Demo, I also created connection using ODBC data source administrator. Am I following the write methods or is there something I am missing in these steps?
I have also tried using ODBC as well:
What is it that I might be doing wrong?