ddkdavid

I have tried to configer jasper report to use the SQL 2005. It does not understand the drivers. I went trhough all these steps below but the JDBC drivers for SQL 2005 were not being recognised by Jasper server What should i do to electify this issue Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver Extract to a good location. I chose c:\program files to extract to. Copy the sqljdbc4.jar to your installation directory which by default is: c:\program files\jasperserver-pro-3.5.1\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib Restart JasperServer (there is a shortcut in the start menu to restart it). Log into JasperServer’s web site. http://YourServer:8080/jasperserver-pro Go to View | Repository. Click the second icon called Add Resource and select Data Source. Choose JDBC Data Source and click next. Provide any Name, Label, and Description. For the driver put this: com.microsoft.sqlserver.jdbc.SQLServerDriver For the URL put this: jdbc:sqlserver://ServerName:1433:databaseName=MyDatabase; Enter the username and password. Select a time zone. Click Test and it should succeed.

I have tried to configer jasper report to use the SQL 2005. It does not understand the drivers. I went trhough all these steps below but the JDBC drivers for SQL 2005 were not being recognised by Jasper server What should i do to electify this issue Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver Extract to a good location. I chose c:\program files to extract to. Copy the sqljdbc4.jar to your installation directory which by default is: c:\program files\jasperserver-pro-3.5.1\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib Restart JasperServer (there is a shortcut in the start menu to restart it). Log into JasperServer’s web site. http://YourServer:8080/jasperserver-pro Go to View | Repository. Click the second icon called Add Resource and select Data Source. Choose JDBC Data Source and click next. Provide any Name, Label, and Description. For the driver put this: com.microsoft.sqlserver.jdbc.SQLServerDriver For the URL put this: jdbc:sqlserver://ServerName:1433:databaseName=MyDatabase; Enter the username and password. Select a time zone. Click Test and it should succeed.