Forum Discussion

clarksj71's avatar
clarksj71
Occasional Contributor
13 years ago

JDBC Connection with JTDS to MS SQL SERVER 2000

Has anyone used JTDS to make a JDBC Connection to MS SQL SERVER 2000. I'm using open source (free SOAP UI). Trying to establish the Drive and Conection String. So that I can add Database validation, but not getting passed the JDBC connection. Any help would be appreciated.

Using this Driver:
net.sourceforge.jtds.jdbc.Driver

Using this connection string:
jdbc:jtds:sqlserver://MSSQLSERVER01:5004/sv_data;user=Sclark;password=AbC123!

I'm getting an error:
com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [net.sourceforge.jtds.jdbc.Driver], connectionString [jdbc:jtds:sqlserver://MSSQLSERVER01:5004/sv_data;user=Sclark;password=AbC123!]

I believe I have the Driver information correct in the
net.sourceforge.jtds.jdbc.Driver


I have placed the jcifs-1.3.17.jar in the \bin\ext directory(full path: C:\Program Files\SmartBear\soapUI-4.5.1\bin\ext)

Any other ideas???
  • clarksj71's avatar
    clarksj71
    Occasional Contributor
    13 years ago
    regarding the jtds-1.2.5.jar. thanks for asking. I missed it in the setup...because I couldn't locate it when I downloaded the driver. Just put in in place...and my connection worked!! thanks