Converting between a SqlAlchemy url to a pyodbc connection string

Question

I have an app that uses both pyodbc and SqlAlchemy for reasons (yes I know about engine.execute())

As a result I have to have a connection string in two formats:

mssql+pyodbc://./MyDb?APP=Python App
DRIVER={SQL Server};Server=localhost;Database=master;Trusted_Connection=Yes

Is there some function to let me convert from one to another so I can only have one configuration string in my configuration file.

Simeon Visser · Accepted Answer · 2015-01-14 13:40:43Z

1

Store each of the components of the database details in the configuration file (server, database name, settings, etc) and write two functions that construct the strings for SQLAlchemy and pyodbc.

For SQLALchemy you can also use the sqlalchemy.engine.url.URL object for this purpose (this object can be used in various places but also to construct the string).

answered Jan 14, 2015 at 13:40

Simeon Visser

123k19 gold badges192 silver badges185 bronze badges

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

Collectives™ on Stack Overflow

Converting between a SqlAlchemy url to a pyodbc connection string

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