too many connections

[blinx]

I keep getting the error "too many connections" when i try to run a piece of ASP code.
I can look at the mysql database variables and see the max_connections = 100 but when i use mysql administrator for windows 1.04 i can see the process list which has only 25 - 30 threads does the number of connections relate exactly to the number of threads and if so why is the site crashing when there are only 30 threads ?
Also i thought that by closing a recordset and setting it to nothing i would get rid of the connection object but mysqladmin reports the connections as being still in sleep mode.
Can someone tell me the normal way of going about this when you need lots of recordsets for certain calculations ?
cheers
lee b

 

[blinx]

I've found out that two things may help me, resetting the value for max_connections and table_cache, but how do i do that? if i change the values in the my_conf file then do i have to restart the server ? I'm also on a cobalt raq 550 and none of the files seem to be where i'd expect them !
cheers for qany help

lee b