Bump version of pymssql to 2.2.1

wintersrd / pipelinewise-tap-mssql

Pipelinewise tap for Microsoft SQL Server

GNU Affero General Public License v3.0

14 stars 48 forks source link

Bump version of pymssql to 2.2.1 #8

Closed divv closed 2 years ago

divv commented 3 years ago

(Latest at time of commit) Avoids an issue when connecting to Azure SQL databases:

pymssql.OperationalError: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (xxx.database.windows.net)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (xxx.database.windows.net)\n')

Issue is believed to be related to lack of SSL support in the bundled version of FreeTDS in pymssql v2.1.5

aaronsteers commented 3 years ago

@wintersrd - Any thoughts on this PR?

In case it is helpful, here's a link to the related slack thread in Meltano Slack: https://meltano.slack.com/archives/C01UW1W4D5Y/p1623992323018800