hi,
try changing to freeTDS or some other JDBC driver. There are many problems
with the jdbc-odbc bridge.

-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of naidu
Sent: Sunday, July 29, 2001 9:37 AM
To: [EMAIL PROTECTED]
Subject:


hi all,

        please help us to find a solution for the following error coming out
when
we are trying to execute a sql statement,

S1000: [Microsoft][ODBC SQL Server Driver] Connection is busy with results
for another hstmt


scenario:
In a servlet we are using multiple sql statement with single connection,
we have tried both the ways of Preparedtatement and direct statement(simple)
still the error persists.
We are using the MSSQL server as database, the driver used is Sun JDBC-ODBC
bridge driver.

thanks in advance for the help.

Regards
Naidu Babu.

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Reply via email to