Do you have the sqljdbc_auth.dll file in your SoapUI /bin directory (or possibly \Windows\System32)? I think this is necessary for trusted connections.
No, I don't see that file (sqljdbc_auth.dll) anywhere on my system.
I was able to get around the problem by switching my license from Ready!API to SoapUI Pro V5.2.1. Apparently that version of Soap uses Java V7 and it's Java V8 that no longer supports the driver. Using SoapUI, the project runs perfectly.
Unfortunately, it appears that I will be forced to fix this when our license for SoapUI Pro expires early next year as the SoapUI splash screen says that there will not be any more renewals given by SmartBear for SoapUI and I'll have to move back to Ready!API. At least that gives us 4 months to get a fix in place.
Thanks for the suggestion,
ABG
I have the same issue. I am connecting to Excel using the following comment
sql = Sql.newInstance("jdbc:odbc:DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=${path};ReadOnly=True","","", "sun.jdbc.odbc.JdbcOdbcDriver")
Ready API 1.3 works just fine for the the above script. But any version beyond that throws the following error
*************************************************
java.lang.NullPointerException
Thu Oct 20 16:39:09 EDT 2016:INFO:sun.jdbc.odbc.JdbcOdbcDriver
*************************************************
Anyone else resolved this issue.
