Developer_jasper Posted December 3, 2008 Share Posted December 3, 2008 Hi all,I want to connect sql server 2000 to jasperserver3.0 Linux edition.Someone in forum suggested to place jtds1.2.2 jar file into following location:<Tomcat directory>commonlib OR<Tomcat directory>webappsROOTWEB-INFlibI have placed this jar file in both locations. Keep in mind it is Linux edition so i think for that reason i cant see any jasperserver folder in webaaps instead i have only got ROOT.I then rebooted server but it doesnt seem to connect.Driver and URL information is as follows:Driver: net.sourceforge.jtds.jdbc.DriverURL: jdbc:jtds:sqlserver://10.1.1.7/<database>;instance=where i am not sure what would go after instance = so i have tried adding database name and then after tried omitting instance= but no joys at all!Any help would be highly appreciated.Many thanks in advance. Link to comment Share on other sites More sharing options...
swood Posted December 4, 2008 Share Posted December 4, 2008 jTDS works like a charm - better than Microsoft's crappy JDBC drivers for SQL Server.You should not need to add "instance" as a property, unless your SQL Server environment uses named instances. See jtds.sourceforge.net/faq.html#urlFormat Is there a stack trace showing the problem? ShermanJaspersoft Link to comment Share on other sites More sharing options...
Developer_jasper Posted December 5, 2008 Author Share Posted December 5, 2008 Thanks swood, I have tried it without instance but it doesnt work and it gives these threads. and i have tried adding and removing port number which is 1433 as defalut but no joys. P.S what version of java is recomended of jTDS driver?Many thanks in advance Code: Post Edited by Developer Jasper at 12/05/08 09:15Post Edited by Developer Jasper at 12/05/08 09:25 Link to comment Share on other sites More sharing options...
swood Posted December 9, 2008 Share Posted December 9, 2008 10.1.1.7 can't be reached. There is a network or network configuration issue. Exception Message: java.sql.SQLException: Network error IOException: Connection refused: connectLevel: SEVEREStack Trace: net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385) net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50) net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182) it.businesslogic.ireport.connection.JDBCConnection.getConnection(JDBCConnection.java:105) it.businesslogic.ireport.connection.JDBCConnection.test(JDBCConnection.java:404) jTDS 1.2 is fine. ShermanJaspersoft Link to comment Share on other sites More sharing options...
Developer_jasper Posted December 9, 2008 Author Share Posted December 9, 2008 Thanks for reply, Sherman. 10.1.1.7 is IP address of database server and other applications can easily be connected to this database. Any suggestion ? Many thanks... Link to comment Share on other sites More sharing options...
samerzohdi Posted July 12, 2011 Share Posted July 12, 2011 what are the exactly configrantions in the default_master file? I can connect to iReport but I can't deploy JS. this is my confg in iReport:JDBC Driver: MS SQLServer (net.sourceforge.jtds.jdbc.Driver)JDBC URL : jdbc:jtds:sqlserver://localhost:1217/MyDBin the defult master file:# app server root directoryappServerDir = D:\\jboss-4.2.1.GA# actual db we're usingdbType=sqlserverdbUsername=sadbPassword=dbHost=localhost# other params have defaults in db props file but can be overridden here dbPort=1217 Thanks,Samer Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now