We use MSSQL as out database, the JDBC - ODBC bridge should never be used in
a production environment. It's not stable (At least for us), and it's
slow...
We bought a third party JDBC driver. It has worked very well for us.
http://industry.java.sun.com/products/jdbc/drivers
The above site has a listing of all the drivers you could want...
Good Luck!
From: naidu [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 29, 2001 2: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, 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
