godes Posted May 3, 2010 Share Posted May 3, 2010 SQL problems: ORA-00604: error occurred at recursive SQL level 1ORA-12705: Cannot access NLS data files or invalid environment specified Thast the error message wen i test the conection. A friend of mine has done it....just the same as i do, she got it..Ive drop and re-install the oracle and the Irepor many times...it keeps sending that error message.the driver is Oracle (oracle.jdbc.driver.OracleDriver) (yes, ive loaded in classpath (ojdbc14.jar) )the conection is : jdbc:oracle:thin:@localhost:1521:XEUser system, pass systemPlease Somebody HELP ME!!! Link to comment Share on other sites More sharing options...
slow Posted May 3, 2010 Share Posted May 3, 2010 it seems to be not a iReport problem but a Oracle installation related issue...have you tried to access to your Oracle account with a client or programmatically with java/other language? Link to comment Share on other sites More sharing options...
hangman01 Posted May 3, 2010 Share Posted May 3, 2010 Instead of using localhost try 127.0.0.1 in your connection string. I have used that successfully on my computer using the local Oracle XE. Try this connection string: jdbc:oracle:thin:@127.0.0.1:1521:XE Link to comment Share on other sites More sharing options...
godes Posted May 3, 2010 Author Share Posted May 3, 2010 Im also thinking its an oracle problem. but The home page of oracle works good, and i conecto with the TOAD to make modifications on the database, and all of it works good, but the IReport wont conect.... and i tried 127.0.0.1...its the samePost Edited by godes at 05/03/2010 17:56 Link to comment Share on other sites More sharing options...
baggypants Posted May 4, 2010 Share Posted May 4, 2010 First tip of using oracle which has alwasy stood me in good stead.Always, always google any ORA errors you get. For example http://www.dba-oracle.com/t_ora_12705_error.htm or even http://forums.oracle.com/forums/thread.jspa?messageID=1098480 Link to comment Share on other sites More sharing options...
sadakar Posted March 4, 2014 Share Posted March 4, 2014 I have the same problem now.. How did you solve it ? It's urgent.. Link to comment Share on other sites More sharing options...
sadakar Posted March 4, 2014 Share Posted March 4, 2014 the database is not in my local machine .. host is some thing like 192.168.2.123 When I connect to databse using SID as orcl in SQL developer it is working but it is not working in iReport.... Link to comment Share on other sites More sharing options...
atman Posted March 26, 2014 Share Posted March 26, 2014 Maybe the problem is then same of this thread:http://community.jaspersoft.com/questions/530818/ora-01882-timezone-region-not-found-datasource 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