Hi,
First of all, this tutorial is great and has helped me a lot.
I am using your code (adjusted) for updating my database but I am having problems with it. It compiles with no errors but when I try to change the fields, I get the error below. I have tried your other code for Displaying and Inserting records and they work fine. I don't know why this error says "Data source name not found and no default driver specified" since it has worked with the other code. Do you have any suggestions? Please let me know asap.
This is the error message I get:
javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at com.oreilly.servlets.db.UpdateServlet.doPost(UpdateServlet.java:166)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
....
....
....
(a long list continues)
root cause
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3028)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.oreilly.servlets.db.UpdateServlet.doPost(UpdateServlet.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
....
....
....
(a long list continues)