For those who want to set a connection to SQL Server 2008 in iReport Designer, I did this :
1. Download the jdbc driver as described in the article
2. Open iReport Designer
3. Go to Tools>Options>iReport>ClassPath and click on "Add a jar"
4. Go and find the sqljdbc4.jar downloaded before
5. Restart iReport
6. Then you will be able to set a connection to SQL Server using : com.microsoft.sqlserver.jdbc.SQLServerDriver and the
URL : jdbc:sqlserver://localhost;instanceName=name;databaseName=MyDatabase
credit: http://www.rhyous.com/2009/10/27/adding-a-sql-2008-server-as-a-datasource-to-jasperserver/
ไม่มีความคิดเห็น:
แสดงความคิดเห็น