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/kb/articles/Q196/2/71.ASP Windows 95: http://support.microsoft.com/support/kb/articles/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\Services\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/kb/articles/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/[EMAIL PROTECTED]
