SQL SERVER 2000 JTDS JDBC Driver Configuration

[Developer_jasper]

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-INFlib

I 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.Driver

URL: 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.

[swood]

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?

 

Sherman

Jaspersoft

[Developer_jasper]

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:15

Post Edited by Developer Jasper at 12/05/08 09:25

[swood]

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: connect
Level:
    SEVERE
Stack 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.

 

Sherman

Jaspersoft

[Developer_jasper]

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...

[samerzohdi]

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/MyDB

in the defult master file:

# app server root directory
appServerDir = D:\\jboss-4.2.1.GA

# actual db we're using
dbType=sqlserver

dbUsername=sa
dbPassword=

dbHost=localhost

# other params have defaults in db props file but can be overridden here
 dbPort=1217 
 

Thanks,

Samer