Forum Discussion

ronmwhite's avatar
ronmwhite
New Contributor II
6 years ago

SQL Server with JTDS

Has anyone had success using JTDS to connect to MS SQL Server or Sybase? I have client tools working without issue, but, can not seem to get it to work in Snaplogic with the same configuration using JDBC. Please advise.

5 Replies

  • RogerSramkoski's avatar
    RogerSramkoski
    Employee
    6 years ago

    Hello ronmwhite,

    Thank you for posting to our Community! Which version of the jTDS driver are you referring to? Is it the old/original one from SourceForge or a different one from GitHub? In addition, it would help to know what versions of SQL Server and Sybase you’re trying to connect to.

    • ronmwhite's avatar
      ronmwhite
      New Contributor II
      6 years ago

      Is there one better than SourceForge and/or do you have a recommendation? It seems to work well. My config follows. Thoughts?

      Microsoft SQL Server
      12.00.4237
      jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
      1.3.1

      • RogerSramkoski's avatar
        RogerSramkoski
        Employee
        6 years ago

        While we might suggest or showcase certain 3rd party drivers that can meet certain needs, we typically do not go as far as to recommend one over another as it really depends on what your needs are and if the driver meet those needs.

        What I can share with you from working with the jTDS driver in past scenarios is that the latest version, 1.3.1, which you’re using, is no longer being developed by that team through SourceForge as of 2008. That specific version officially only supports up to SQL Server version 2012.

        For SQL Server, have you considered using a JDBC driver from Microsoft? You can find their options at Download - JDBC Driver for SQL Server | Microsoft Docs.

        For Sybase, they have some JDBC suggestions at SyBooks Online as well.