Error when to create or use data adapter in Jaspersoft studio 5.6.1 and 5.6.2?

[chemat92]

Hi, I am new to jaspersoft. I have some problem. I wanna create new data adapter or use present data adapter in Jaspersoft studio 5.6.1 and 5.6.2, but I have error.

 

It prompt this error :  "Exception, if you want to see more information look into details. Reason : java.lang.ClassNotFoundException : com.microsoft.sqlserver.jdbc.SQLServerDriver."

I have this error when I am using community edition. But when I switched to professional version, this error not prompted. How to solve this issue? Thanks

Here is the error details :

net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:173)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128)
    at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:129)
    at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:165)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:501)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412)
    at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:175)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:145)
    ... 4 more

[james.t]

You need to include the MS SQL Server JDBC JAR file in Jaspersoft Studio.You can download this from Microsoft's website. Then to use them in Studio do this:

1. Right-click on your project in the Project Explorer and then select Build Path->Configure Build Path.

2. From the Libraries tab click Add External JARs...

3. Find your JDBC JAR file