Automic Workload Automation

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Connection to MSSQL 2000 database using JTDS driver doesn't work

  • 1.  Connection to MSSQL 2000 database using JTDS driver doesn't work

    Posted Apr 11, 2018 09:36 AM
    Hello,
    Has anyone tried connecting to MSSQL 2000 database using SQL Agent? If yes, what is correct driver version needed?
    I have tried following versions and none of them appears to work from Automic.

    SQLJDBC 2.0.jar
    SQLJDBC 4.0.jar
    SQLJDBC.jar
    JTDS-1.3.1

    Interestingly we have another automation tool that connects to SQL 2000 database using JTDS -1.3.1 driver without any issues.

    Appreciate inputs.

    Zafar



  • 2.  Connection to MSSQL 2000 database using JTDS driver doesn't work
    Best Answer

    Posted Apr 11, 2018 10:15 AM
    I was able to get the connection to work using 'sqljdbc4-2.0.jar'. Thanks!