Use a good type 4 driver.There are a lot of free ones available , though I
cant think of one from the top of my head.Mail me offline if u still have
problems.
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Peter
> Smith
> Sent: Sunday, November 05, 2000 8:40 PM
> To: [EMAIL PROTECTED]
> Subject: Servlet SQL Problems
>
>
> Hi,
>
>
> 1.I created a table called "users" in a database "content" with MS Access
> 97.
> This databse has been registered to ODBC driver.
>
> 2. I tried to use a servlet (T3.class) to check login.
> This servlet is called by login.html with a form included, which a user
> can input
> username and password.
>
> 3. It worked fine when I input username and password in the HTML
> form first
> time, and click
> a submmit button. However, I got following error message when I refresh
> the login.html
> page, input another set username and password into the form, and click
> the submmit
> button. The servlet engine is Tomcat3.1 run on Windows 98 with
> jdk1.3 as
> a stand alone mode .
>
> java.sql.SQLException: General error
> at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(Unknown Source)
> at sun.jdbc.odbc.JdbcOdbc.SQLAllocStmt(Unknown Source)
> at
> sun.jdbc.odbc.JdbcOdbcConnection.createStatement(Unknown Source)
> at
> sun.jdbc.odbc.JdbcOdbcConnection.createStatement(Unknown Source)
> at T3.doPost(T3.java:72)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper
> .java:503)
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
