Hey!
This is not a servlet question and is off-topic for SERVLET-INTEREST.
I can't say for sure because I don't use Microsoft SQL Server,
but most industrial strength DB servers can configure the number
of concurent connections allowed.
You need to check your DB configuration documentation on
the topic of "number of connections".
If MSSQL can't do that, then consider using another DB server.
Also look at you code and see if you are closing you DB connections
appropriately.
Sans adieu,
Danny Rubis
Lalith Jayaweera wrote:
> Hi Guys,
>
> When trying to connect to the database Sometimes it works and sometimes it
> gives the following ERROR
> message.
>
> SQLException caught : [Microsoft][ODBC SQL Server Driver]Connection is busy
> with results for another hstmt
>
> Thanks in advance
>
> lalith
>
> ___________________________________________________________________________
> 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
