Forum Discussion

vd484's avatar
vd484
Occasional Contributor
15 years ago

connecting to a sql server 2008 database - using JDBC step - getting error

all

I am trying to connect to a Database using JDBC step.

i am getting the below error message. any one encountered this - please help.

using Driver as : com.microsoft.sqlserver.jdbc.SQLServerDriver

"Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later."

Thanks
vd484
  • tkumark's avatar
    tkumark
    Occasional Contributor
    HI

    I am using a free version of SoapUI. I am not able to connect to sql server 2008.

    import groovy.sql.Sql

    sql = Sql.newInstance("jdbc:sqlserver://32esx802\\inst1", "UserName","password", "com.microsoft.sqlserver.jdbc.SQLServerDriver");
    def dbValues = sql.firstRow("Select * from table");

    i am getting the following error.
    java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

    I downloaded the jdbc drives from
    http://www.microsoft.com/downloads/en/d ... laylang=en

    I pasted
    sqljdbc4.jar and sqljdbc.jar
    in C:\Program Files\eviware\soapUI-3.6.1\lib

    I still get the same error
    putting sqljdbc4.jar in C:\Program Files\eviware\soapUI-3.6.1\bin\ext does not help also ( i guess it only used for PRO version)

    Already refered viewtopic.php?f=2&t=4449&p=14945&hilit=Java+Runtime+Environment+JRE+version+1.6+is+not+supported#p14945

    Can some one at least let me know if soapUI 3.6.1 free version support sql server 2008.

    Thanks
  • com.eviware.soapui.support.GroovyUtils.registerJdbcDriver( "net.sourceforge.jtds.jdbc.Driver" )
    this is the solution.

    And no it is not a feature of soapui pro.
    If it is still not working, use Soapui 3.5.1, it is less buggy & it works without that.