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
- went to Microsoft ODBC
- User DSN
- Enter DNS ,TNS SERVICE NAME, USERID
- 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.