I have JasperSoft Studio and when creating a new adapter I get the error message No Suitable Driver Found when I test connection. I checked my version of Java and downloaded the JDBC driver from Microsoft. When creating the new Adapter I selected the Database JDBC Connection and then the next page on the driver selection I have tried all the MS SQL Server options and get the same error no suitable driver
On the Adapter connection page, I added the location of the jar files under the Driver Classpath tab but I still get the same error.
I even created an ODBC connection to the database which does connect successfully but when I try to select the JDBC ODBC driver options I also get the same error.