Saturday 26 March 2016

Creation SQL Server Data Source Connection on Jasper Server Using JDBC

Creation SQL Server Data Source Connection on Jasper Server Using JDBC

Jasper report using SQL server datasource.

We need to JDBC driver to connect SQL server. By default on local machine don't have JDBC driver.
Download JDBC driver and set the class path variable in environment variables point to JDBC driver.

In below video I have shown below things to setup SQL server data source to use in creating jasper report.
  • JDBC download website
  • JDBC-2 drivers based on 32 bit or 64 bit.
  • How to set CLASSPATH
  • How to create JDBC connection.
  • Testing
Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel