search

BuzzCutNorman / tap-mssql

Singer Tap for MS SQL built with Meltano Singer SDK.
MIT License
2 stars 9 forks source link

Adjust TDS Version used by pymsql #78

Open SenneVanstraelen opened 4 months ago

SenneVanstraelen commented 4 months ago

Hello

I need to be able to connect to SQL Server 2005. For this I need to adjust the TDS Version, like in the variant by Rob Winters.

Is there a way to do this? I cannot seem to find it in the documentation.

Thanks!

BuzzCutNorman commented 3 months ago

Sorry to say but buzzcutnorman tap-mssql does not currently have a way to tell pymssql the TDS version you want it to use.

I took a look at pipelinewise-tap-mssql by Rob Winters. He uses pymssql exclusively and can pass that directly during the connection creation. The singer-sdk I used for creating buzzcutnorman tap-msql uses pymssql in conjunction with SQLAlchemy. After a quick search I didn't find a quick way to add this. I will look into it more. This tap also supports pyodbc which might be able to connect to SQL Server 2005.

Also, if pipelinewise-tap-mssql by Rob Winters has the functionality you need by all means use it. It is the default tap-mssql on hub.meltano.com because it is production ready and battle tested.

SenneVanstraelen commented 3 months ago

Thanks for looking into it. With the pipelinewise-tap-mssql by Rob Winters I'm experiencing other issues related to the table selection and the version of the database and TDS.

The ODBC route is worth looking into, however, I need to find a driver that works on Linux and can connect to SQL Server 2005 (TDS 7.0). That information doesn't seem to be readily available on the internet, any ideas on which driver to use, I know for a fact that 18 does not work.

BuzzCutNorman commented 3 months ago

Thank you for the expanded context. I found this link to previous Microsoft ODBC drivers for Linux. Maybe version 13 or 11 might work.

https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16&tabs=debian18-install%2Calpine17-install%2Cdebian8-install%2Credhat7-13-install%2Crhel7-offline#previous-versions