DB Probs....

[2005 IR Help]

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:

null

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.

 

Thanks

 

 

 

 

 

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,

 

Thanks

 

 

 

 

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?

 

Thanks.

 

 

 

 

 

 

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.

 

Giulio