Error with pd_to_mssql

[PurenBITeam]

Hello everybody,

great package, but I get a strange error message when I try the mentioned above function with a sqlalchemy engine connected to ODBC.

See code below:
engine = create_engine(constring2)
engine.url
mssql+pymssql://XXXXXX:***@azurexxxx

import d6tstack.utils as du
du.pd_to_mssql(I_df, engine, "t_abda_pacapo01_stage", if_exists="replace")

This results in the error message below:
argument of type 'Engine' is not iterable

Any ideas how I can solve this?

thanks and br

christoph

[PurenBITeam]

Add:
when I try pd_to_mssql with the constring directly and not with the engine object...I get the following error:
(pymssql.InterfaceError) Connection to the database failed for an unknown reason.
(Background on this error at: http://sqlalche.me/e/rvf5)

Already checked out the url, but cannot really figure out the problem. The connection works when i create an sqlengine.

thanks

[mengmer]

I got this problem too