Too Many Connections Exception

Hai
I am using Tomcat server as webserver and SQL Server as database server. Both reside at same.
And I am using applets to get data. First time when i am opening in the browser i am getting data perfectly. If i am opening the same page in another page it is showing SQL Excepttion: Too many connections.
What i am doing is in init() method of the applet i am getting connection.
In destroy() method of applet i am making connection = null.

Your database is set up to not allow more than one connection at a time. Presumably you have a single-user license for SQL Server. You have a couple of options:
1) Buy more SQL Server licenses. (This gets expensive really fast, particularly if you have a large user population who might be using your applet).
2) Rearchitect the app so that something on the server is managing the database connections. Because the applet creates a connection, each instance of the applet will create a separate connection. If the applet communicated with something on the server which managed the connections, the server could create 1 connection or only a few connections and then use them to handle the requests.

Hai
thanks for ur reply. but when i am using the same SQL server in jsp i am not getting problem After ur reply. i made 3 connection objects in the same jsp page and tried to retrive data it is worked fine but where is in applet it is showing the error.

Hi there,
Is that IE 6.0 you are using?

I have a similar problem with it. Even if I remove the .class file, IE loads the applet.

ravee.
[ November 25, 2002: Message edited by: Ravee Bhat ]