SqlAlchemy connection string using pymssql

Question

Is there an equivalent of odbc_connect in pymssql using freeTDS driver?

For example using pyodbc I can use connect within the connection string itself and then pass all required parameters:

conn_string = ("mssql+pyodbc:///?autocommit=true&odbc_connect={}".format(parameters)

Is it possible to use &connect={} within the string using pymssql & freeTDS in SQLAlchemy?

Gord Thompson · Accepted Answer · 2022-02-14 13:29:37Z

1

No, because odbc_connect= is part of the pyodbc driver code in SQLAlchemy and the pymssql driver code has no corresponding option. That said, pymssql was actively supported in SQLAlchemy until recently, so if you need to pass any extra options to pymssql there is probably a way to do it. Check the documentation for details.

answered Feb 14, 2022 at 13:29

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SqlAlchemy connection string using pymssql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related