Jump to content
Changes to the Jaspersoft community edition download ×

DB Probs....

2005 IR Help

Recommended Posts

By: hillary - wikkitt

DB Probs....

2005-10-18 08:09

Hey all,


I'm trying to connect to a SQLServer DB that is also being used by my JAVA program. But iReport is not connecting. I have no probs connecting with a JDBC with my program but iReport gives a


General problem:


Please chack your username and password. The DBMS is running?


(it really does say "chack")


I have created a new username and password, installed new drivers, restarted the DBserver and still not working. I have to connect through an ODBC. That's fine for a while but not for long.


I've looked everywhere I can think of and found nothing.

Any help would be great.








By: hillary - wikkitt

RE: DB Probs....

2005-10-19 07:25

It's the SQL Server 2000 Type 4 JDBC driver dowloaded from microsoft.com.


my con string is jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Test


This is the same string my program uses and it works fine there. I don't see why it wouldn't work here.


Thanks for the help







By: hillary - wikkitt

RE: DB Probs....

2005-10-20 13:03

Ok, I reinstalled iReport and everything seems to work now,







By: J. Brett Howell - jbretthowell

RE: DB Probs....

2005-10-18 11:01

Which driver are you using and what does your connection string look like?





By: Mary - maryremillard

DB connection error to derby dbmx

2005-10-21 15:30

I'm using IReports (0.5.1) for the 1st time and I'm having problems connection to my derby database. Since the driver wasn't listed I added it and then added the jar files to my class path. I'm using the following information for the connection:


Driver: org.apache.derby.jdbc.EmbeddedDriver

URL: jdbc:derby:C:/BLCode/gumbo/web/WEB-INF/etc/db/cloudscape/mapperDB

User Name: blahblah

Password: <null>


When I try to create a report I get the following error:

General problem: null

Please check your username and password. Is your DBMS running?

The null exception is coming from it.business.ireport.gui.WizardDialog(1119)


Anybody have any suggestions?









By: Giulio Toffoli - gt78

RE: DB Probs....

2005-10-26 15:15

iReport is not able to set a null password. Use a blank password instead and check "save password".

When you create the datasource, test it with the proper button.



Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...