greenockboy Posted January 13, 2007 Share Posted January 13, 2007 Hi I have recently installed ingres DBMS onto my laptop and decided to install ireport to create some simple reports. I had created a database with Ingres and tried to create a connection in ireport, however when I test the connection I get an exception with a message saying that I need to enter a username and password. The message is:SQL problems: A user ID and password are required to establish a connection.jdbc:edbc://localhost:II7/testdb." I haven't added any username or password to Ingres and can freely access my database without entering any.Any advice on this would be very greatly appreciated. ThanksGB Link to comment Share on other sites More sharing options...
greenockboy Posted January 15, 2007 Author Share Posted January 15, 2007 Hi This is just to say that I'm not restricted to using ingres. If anyone can provide the details to create a connection to a MS Access database then that would also be appreciated...........anything that will allow me to actually start using ireport. Many ThanksGB Link to comment Share on other sites More sharing options...
jmurray Posted January 15, 2007 Share Posted January 15, 2007 Would the 'username' refer to a database schema or user, not the database application itself? Link to comment Share on other sites More sharing options...
greenockboy Posted January 16, 2007 Author Share Posted January 16, 2007 Thanks for your reply j Unfortunately my knowledge of ireport is so limited that I don't know the answer to your question. It's very frustrating not being able to use it for the lack of something apparently so insignificant. I actually have the manual at work but was not able to work out how to get around my problem. Hopefully I'll have it solved soon as there must be a few people who have already managed to connect to ingres..............and one will post the solution. Many ThanksGB Link to comment Share on other sites More sharing options...
greenockboy Posted January 20, 2007 Author Share Posted January 20, 2007 Hi Well I managed to work out the problem, I was using the wrong driver.The correct driver was:ca.ingres.jdbc.IngresDriver;I then substituted edbc for ingres in the url....and hey presto.RegardsGB 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