Hi everyone - I have configured a block to connect...
# ask-community
r
Hi everyone - I have configured a block to connect to SQL Server using sqlalchemy connnector. And I am specifying { "driver": "ODBC Driver 17 for SQL Server"} as additional connection arguments. When I try to get the engine, I get a warning - SAWarning: No driver name specified; this is expected by PyODBC when using DSN-less connections engine = create_engine(**engine_kwargs). I am lost what I am doing wrong. Also I did a print of engine_kwargs and I got this as part of my print statement - {'url': mssql+pyodbc://testuser:***@test/reportserver, 'connect_args': {'driver': 'ODBC+Driver+17+for+SQL+Server'}} so it looks like the additional configuration is getting passed. This just seems to be a warning and the code still works fine that references that engine object.