search

s7clarke10 / tap-sybase

A Singer Tap for Sybase Databases, it should be compatible with Pipelinewise and Meltano
GNU Affero General Public License v3.0
1 stars 4 forks source link

Support older versions of Sybase via TDS version 4.2 #25

Open s7clarke10 opened 6 months ago

s7clarke10 commented 6 months ago

Problem Updates to FreeTDS which is used by pymssql has broken access to older versions of Sybase.

Older versions of Sybase do not support the keyword AS.

Resolution Will try to connect with no TDS setting, defaulting to the highest version.

If TDS version 5.0 is not supported, drop back to TDS 4.2. For more details see - https://www.freetds.org/userguide/ChoosingTdsProtocol.html.