#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    2
    Rep Power
    0

    "maximum connections" problem


    Hi all,

    I wrote some PHP page and had "maximum connections..." when connectting to database although I open/close connections manually.

    I use IIS web server , MySQL database server on Windows 2000 Professional.

    How to fix this problem? any problem among PHP,IIS and MySQL

    please help me.
    thanks.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Thailand
    Posts
    6
    Rep Power
    0
    I read on the Microsoft site (knowledge base article 308192) that Windows 2000 Professional is limited to 10 concurrent connections, and each client generally requires 3 connections.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    2
    Rep Power
    0
    So, what am I suppose to do? I am new with IIS and I wish to do it on Apache, but requirements are clear.
  6. #4
  7. No Profile Picture
    Stumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,409
    Rep Power
    4538
    There are two connection issues. IIS on W2K Pro is limited to 10 user connections. Your database server on W2K Pro will be a desktop edition of SQL Server that probably has connection limits.

    The solution, although expensive, is to get a server version of Windows and the server version of SQL Server with the Internet Connection license.

IMN logo majestic logo threadwatch logo seochat tools logo