Hi all,
There is a limitation on Win98 when a client app using mm.mysql driver doing
extensive queries to MySQL 3.23.x frequently encounters a connection lost
error.
Error msg is something like:
'java.lang.Exception: Cannot connect to MySQL server on localhost:3306. Is
there a MySQL server running on the machine/port you are trying to connect
to? (java.net.SocketException)'
I've found a very useful piece of info. In brief, you've got to
change/create the registry key for max concurrent TCP connections:
Pls see: http://www.proxyplus.cz/faq/articles/EN/art10002.htm
If the above URL is unavailable, here is the important part:
<snip>
Solution:
There are following articles in Microsoft Knowledge base:
Windows NT/2000:
http://support.microsoft.com/support.../Q196/2/71.ASP
Windows 95: http://support.microsoft.com/support.../Q170/7/91.ASP
Some users reported to us there is another solution for Windows 95/98/Me
which solved the problem at all. Windows 95/98/Me allows up to 100 (default
value) of concurrent TCP connections. It looks like when the number of
connection reaches the limit 10055 error is reported. The solution is to
increase the limit of simultaneous connections. You can do it by
changing/creating value of the key:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Servic es\VxD\MSTCP\MaxConnection
s
If you will create the MaxConnections variable key use STRING type for it
(early Windows 95 used DWORD probably). Set the value to 300 for example,
restart the Windows and check whether 10055 problem disappeared.
There is MS Knowledge Base article which describes the meaning of MSTCP
registry entries:
http://support.microsoft.com/support.../Q158/4/74.ASP
</snip>
My 2 cts worth... I LOVE THIS GUY!
HTH,
Al.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
