the JDBC-ODBC bridge is not suitable for production, it's only for
testing.
I must recomend that you look at other ways of comunicating with your
database.
http://www.microsoft.com/sql/downloads/2000/jdbc.asp
This would be the "free" driver you would use for microsoft SQL, but it
is only a beta version.
if you have some money in your pockets you could look at datadirect
technologies (www.datadirect-technologies.com),
or atinav.com. The microsoft driver is a previous version of the
datadirect technologies driver.
hope it helps
-reynir
> -----Original Message-----
> From: Gurmeet [mailto:[EMAIL PROTECTED]]
> Sent: 12. mars 2002 10:55
> To: Tomcat Users List
> Subject: RE: CONNECTION BUSY
>
>
> Yes, you are right . I am using JDBC-ODBC bridge.
>
> Regards
> Gurmeet
>
> -----Original Message-----
> From: Reynir Hübner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 12, 2002 4:17 PM
> To: Tomcat Users List
> Subject: RE: CONNECTION BUSY
>
>
>
> The errormessage implies that you are using odbc bridge to
> access MsSQL.
>
> If so, you might want to switch over to a native JDBC driver (for
> example the merant / Microsoft driver).
> Please post more informations on which JDBC driver you are using.
>
> - reynir
>
>
>
> > -----Original Message-----
> > From: Gurmeet [mailto:[EMAIL PROTECTED]]
> > Sent: 12. mars 2002 10:45
> > To: Tomcat Users List
> > Subject: CONNECTION BUSY
> >
> >
> > How do I resolve
> >
> > "[Microsoft][ODBC SQL Server Driver]Connection is busy with
> > results for another hstmt"
> >
> >
> > problem. This is coming only if I am executing a no. of SQLs
> > in quick succession.
> >
> > Please Help.
> >
> > Regards
> > Gurmeet
> >
> >
> > --
> > 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]>
