Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite
1

I have come across this error when I was trying to insert data from front end (using JSP) to back end (Oracle 10g):

java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12154:
                       TNS:could not resolve the connect identifier specified

Steps followed:

  1. went to Microsoft ODBC
  2. User DSN
  3. Enter DNS ,TNS SERVICE NAME, USERID
  4. When I click on "Test connection", the result was "Connection Successfull"

When I run my frontend JSP which has a text box and a button, I get the error mentioned above when I click on the button.

share|improve this question
Is the frontend running under a different account to the one you're using to test the connection? Is the DSN set up for user not machine? – PeteH Jan 8 at 12:51
yes front end is running in one machine , and the database i'm using is stored else where ..and i have setup DSN where i have frontend – user1845538 Jan 8 at 13:07
PeteH's question asked you about the user, not the computer. Is the user you used to create the DSN the same as the user running whatever app server you're using for your JSP pages? – Mat Jan 9 at 9:05
@MAT: yes both are same please help me out with solution – user1845538 Jan 9 at 10:02

migrated from stackoverflow.com Jan 9 at 3:10

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.