Failure to connect MS SQL as Backend

Question

Failure to connect MS SQL as Backend

sanjayvr opened this issue 5 years ago · 0 comments

Hi,

I am trying to connect MS SQL 2016 as the backend and am passing the connection URI as below -

knowledge_repo --repo mssql+pyodbc://username:password@servername/database:table?driver=ODBC+Driver+17+for+SQL+Server

But I keep getting error saying sqlalchemy.exc.InterfaceError: (pyodbc.InterfaceError) ('IM002', u'[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

From my investigation, it should have been resolved when I appended ?driver=ODBC+Driver+17+for+SQL+Server to the connection URI but had no luck. Has anyone connected SQL Server as the backend and if so, can you please help?

Thank you.