Menu
▾
▴
#29 Support for Azure SQL
A user on the forums reported that connecting to Azure SQL is not possible. Most probably this is because of the use of the dbuse function, which tries to change the database after we login to the server. Azur SQL doesn't support changing the database.
As a workaround the FreeTDS team added the DBSETLDBNAME macro to sybase.h:
https://lists.ibiblio.org/pipermail/freetds/2012q4/028168.html
https://github.com/tds-fdw/tds_fdw/issues/23#issuecomment-104091427
So - if we can apply this strategy, we can also connect to Azure SQL.
The topic where this came up was: https://zeoslib.sourceforge.io/viewtopic.php?f=40&t=28639
This patch also might help in connection with contained databases:
https://stackoverflow.com/questions/26106984/connect-to-mssql-contained-database-with-python-on-ubuntu
Unfortunately a first approach didn't work out of the box in [r7331]...
Related
Commit: [r7331]
Last edit: marsupilami79 2021-02-15