Scenario: Com.microsoft.jdbc.sqlserver.SQLServerDriver JDBC Driver is selected in Iroport; Classnotfounderror error occurred while connecting
When you see the following red database driver. Don't be silly to click on the test. Must be an error.
1. Because the system does not have your SQL Server jar.
So you should now download your corresponding jar.
Here I offer the SQLServer2008. (because I only use MySQL and SQL Server two kinds.) MySQL is already integrated into the system. So I had to download SQL Server.)
http://www.microsoft.com/zh-cn/download/confirmation.aspx?id=21599
2. If you can put the corresponding jar package in the ireport installation directory! (Lest you delete something by mistake next time.) Something went wrong. )
Then add the "add JAR" to your classpath.
Such IReport (I use IReport5.6.0, so the following interface is like this.) Others will find their own classpath. ) only to check that your environment has com.microsoft.jdbc.sqlserver.SQLServerDriver this driver class
3. If your SQL Server is not well-equipped. That's your problem.
Let's look at another blog post!
SQL Server 2008 Open sa account and how to connect using JDBC
Http://www.cnblogs.com/shortboy/p/3253090.html