Forum Discussion

DavidEtcell's avatar
DavidEtcell
Occasional Contributor
12 years ago

[R]SQLServerDriver as Datasource won't return correct result

Hi Everybody!

I am trying to connect to an MS SQL server as a datasource, but simply can not get the correct results returned.

I am connecting to Sql Server Management Studio and getting the correct results, however the datasource in SoapUIPro (4.6.4) is not returning the same result.

I am using the same server name, login and password to connect:



But when I execute the simple query:



There is nothing shown in any of the SoapUI logs, and it always returns 0 results.

I have tried checking the stored procedure box in SoapUI, and changing the query to execute the sp as an sp, but that has the same result:


Does anyone know what could possibly be wrong here?

1 Reply

  • DavidEtcell's avatar
    DavidEtcell
    Occasional Contributor
    12 years ago
    Ok so I solved this. I'll be making a post in the SoapUI Pro bugs section, but the issue is with the included SQL Server JDBC driver.

    I used a groovy script as the datasource to test the driver against the jtds driver available from sourceforge.

    MS jdbc result:


    jtds jdbc result:


    Cheers,

    David