Just a guess, but it sounds like your not closing your resultset or
connection. Have you thought about going with JDBC and a connection pool?
Tom Kochanowicz
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
SSRAJAGOPAL
Sent: Thursday, May 11, 2000 10:13 PM
To: [EMAIL PROTECTED]
Subject: Query on SQL server
Hi all,
I am doing my project using servlets . Recently I shifted my
application from MS-Access to SQL Server 7.0 . When i try to access the
application and run any of the servlets it gives me the following error
" Connection is busy with results of another hstmt")ODBC -HY0000
Has anyone encountered this problem . ?If so what should be done to
remove this ?.
Note : I am using IIS and Servlet Exec utility ro run my servlets
Thanx in advance
Regards,
S.S.Rajagopal
___________________________________________________________________________
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
___________________________________________________________________________
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
