I am setting up Azure sql project in DBT Core, but I keep on getting the below issue–
(‘01S00’, ‘[01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0) (SQLDriverConnect)’)
I have installed dbt-sqlserver adapter but when I try to initiate this project it says ‘no sample profile found’ so I create the profiles.yml file manually with below details.
driver: SQL Server
In driver value…I have tried like --‘ODBC Driver 17 for SQL Server’ and ‘ODBC Driver 18 for SQL Server’, all are installed in my window VM.
any help would really be appreciated.