Service Virtualization

  • Private Community
Back to discussions
Expand all | Collapse all

JDBC Step - MSSQL DB connection error

  • 1.  JDBC Step - MSSQL DB connection error

    Posted Aug 27, 2014 04:44 PM


    Hi,

     

    I'm having issue connecting to a mssql server using JDBC step in lisa 7.5. I used below driver and connection string as per the default format and I get error. I'm I using it wrong?

     

    driver                           : com.microsoft.sqlserver.jdbc.SQLServerDriver
    connecting string     : jdbc:microsoft:mysql://{{server}}:1433

     

    Error : Message: Connection failed. Please check your settings to ensure they are correct. If you are using MSSQL you need to match the URLs with the driver. They are slightly different.

     

    I changed the connection string slighly - without the'microsft' in it and got below error.

    jdbc:sqlserver://{{server}}:1433 - without the 'microsoft' in it

    Error : java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
    Thanks in Advance