Hi all,
I am setting up Azure sql project in dbt Core, but I keep on getting the below issue–
Database Error
(‘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.
testdemo:
target: dev
outputs:
dev:
type: sqlserver
driver: SQL Server
server: .windows.net
port: 1433
database: RnD
schema:
user:
password:
target: dev
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.