Installing Jasper Reports on system using MSSQL

[mhoppes]

I've got the Java SDK installed. I have my path set. I've got the Jasper Reports ZIP file downloaded. However, when I am looking through the server.xml file I see that I need to change two settings.

1 is:
driverClassName

2 is:
url

Right now they are setup for mysql, but I am using mssql on Windows. Does anyone know what these need to be changed to so that it connects to Windows, and do I have to download or do anything else special?

[Deuce]

Hi,

1 should be:
com.microsoft.sqlserver.jdbc.SQLServerDriver

2 should be:
jdbc:sqlserver://localhost

You'll also need to download and install the SQL server jdbc driver from Microsoft.
I just copied the sqljdbc.jar file to the catalina\common\lib directory.

This works fine on my box, ymmv.

[mhoppes]

Hi,

1 should be:
com.microsoft.sqlserver.jdbc.SQLServerDriver

2 should be:
jdbc:sqlserver://localhost

You'll also need to download and install the SQL server jdbc driver from Microsoft.
I just copied the sqljdbc.jar file to the catalina\common\lib directory.

This works fine on my box, ymmv.

Well I did that.... I set the username and password in the server.xml file... but when I try to log in it kicks me out.. with no helpful information.

How do I find out why it won't let me in.. and why does the default login show up as dsf?

[Deuce]

Looks like it's not connecting to the database.

Try writing the url like this:
"jdbc:sqlserver://localhost:1433;databaseName=yoursugardbnamehere;"

Other than that, I don't know what to tell you...

[ftreml]

if you run jasperreports on windows, maybe the jdbc-odbc-bridge works. Create an ODBC datasource for your mssql database using the odbc administrator in the Windows system panel. then use "sun.jdbc.odbc.JdbcOdbcDriver" as driver and "jdbcdbc:<datasource name>" as URL.

[mhoppes]

if you run jasperreports on windows, maybe the jdbc-odbc-bridge works. Create an ODBC datasource for your mssql database using the odbc administrator in the Windows system panel. then use "sun.jdbc.odbc.JdbcOdbcDriver" as driver and "jdbcdbc:<datasource name>" as URL.

I tried that and it doesn't do anything different. I get to the login page of Jasper Reports and enter my username and password and it just throws me back to login with an "Invalid username/password" message.

Catalina seems to be logging almost nothing in the log directory. Is there some place I can go to see what is going wrong?