Well u need to use Type -V drivers for SQL, one of them is Sprinta 2000 or Opta 2000 from i-net software.
You can download the trial version from www.inetsoftware.de Gurmeet -----Original Message----- From: Sudhir Kumar [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 12:06 PM To: 'Tomcat Users List' Subject: RE: Problem with SQL Ya.. it is the same JDBC-ODBC bridge.. any solution for this ?? -----Original Message----- From: Gurmeet [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:58 AM To: Tomcat Users List; [EMAIL PROTECTED] Subject: RE: Problem with SQL Are u using the same JDBC-ODBC bridge in case of oracle and Access also? Anyway this problem comes becuase JDBC-ODBC bridge drivers are not serialisable. Gurmeet -----Original Message----- From: Sudhir Kumar [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:07 AM To: 'Tomcat Users List' Subject: Problem with SQL Hi, I have a problem with the SQL Database. I have connected to SQL server through JDBC-ODBC bridge. In the code since i need to fetch the data inside a number of loops one inside the other , i have used 5 different resultset objects , 5 statement onjects and a single connection object. In each loop i am fetching data from different tables. The code is working fine with Oracle 8 and MS Access Database. But SQl is throwing this exception, Can any one help me out...?? The Exception is : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt Thanks in advance.. Sudhir -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>