Wednesday, 25 April 2012

Connect Ireport to MS SQL Server database

To create a MS SQL Server database in Ireport, you need a sqljdbc driver.

Steps to create MS SQL Server database in Ireport:-

1:- Download sqljdbc (1033\sqljdbc_3.0.1301_enu.exe) driver from
                              http://www.microsoft.com/download/en/details.aspx?id=21599

After downloading driver, extract the sqljdbc4.jar file and paste into this location

                            C:\Program Files \Jaspersoft\iReport-4.0.2\ireport\modules\ext
2:-Start Ireport and go to Tool and then select Optios
                                    


                                            
Click on Class Path tab, click on Add jar tab and browse the sqljdbc4.jar file

                                             

After adding the jar file restart the Ireport.
Now you can create MS SQL Server database in Ireport.

2 comments:

Freddy Arriaga said...

help me please, i have conected ireport with sqlserver, but non php, how i does make it's. please helpe me.

gibsonherry said...

I appreciate this blog to share knowledge about this important topic. Here I found different segments and now I am going to use these new tips with new enthusiasm.
Windows Server Datacenter