context = gx.get_context()
conn_string = (
"mssql+pyodbc://DRIVER={ODBC+Driver+17+for+SQL+Server};SERVER="
+ "......"
+ ";DATABASE="
+ "......"
+ ";Trusted_Connection=yes;"
)
#print(conn_string)
conn = context.sources.add_sql(
name="test", connection_string=conn_string
)
TestConnectionError: Attempt to connect to datasource failed with the following error message: (pyodbc.Error) (‘IM010’, ‘[IM010] [Microsoft][ODBC Driver Manager]
The conn_string is taken from another project where the connection is made with SQLAlchemy.
Expectaion was that the conn_string workd as expected since Great Expectation uses SQLAlchemy aswell