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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
  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

migrated from Jan 9 '13 at 3:10

This question came from our site for professional and enthusiast programmers.

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 '13 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 '13 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 '13 at 9:05
@MAT: yes both are same please help me out with solution – user1845538 Jan 9 '13 at 10:02

Your Answer


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

Browse other questions tagged or ask your own question.