Cannot connect to mssql:

[faywang123]

Hi ,
I have being struggling with vanna.connect_to_mssql using the example:
vn.connect_to_mssql(odbc_conn_str='DRIVER={ODBC Driver 17 for SQL Server};SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypassword')

Inside vanna/base/base.py:

        connection_url = URL.create(
            "mssql+pyodbc", query={"odbc_connect": odbc_conn_str}
        )

The generated connection_url is

mssql+pyodbc://?odbc_connect=DRIVER%3D%7BODBC+Driver+17+for+SQL+Server%7D%3BSERVER%3Dmyserver%3BDATABASE%3Dmydatabase%3BUID%3Dmyuser%3BPWD%3Dmypassword

This apparently failed with connection.

My SQLAlchemy version is 2.0.37.

Please help and thanks!