MSDE on Windows 2000 Pro

Discussion in 'ASP .Net' started by David Lozzi, May 16, 2006.

  1. David Lozzi

    David Lozzi Guest

    Howdy!

    I have a question for all you smarties... I have a ASP.Net application
    running on Windows 2000 Professional and MSDE, same box. While running the
    application, users will randomly receive a too many connections error or
    even a simple Page cannot be displayed. I know some of the limitations of
    MSDE and have managed to fudge my way around them, but what about Win2kPro
    IIS? I'm thinking it won't let me a host an active application on it? This
    app will be seeing 20-30 users at any point. We do have a Win2k3 SQL 2000
    server available but my customer wants to know for sure this is the issue...

    Thanks,

    --
    D a v i d L o z z i
    Data & Web Technology Specialist
    Delphi Technology Solutions, Inc.
    Wilmington, MA
    dlozzi@(remove this)delphi-ts.com - www.delphi-ts.com
     
    David Lozzi, May 16, 2006
    #1
    1. Advertising

  2. David Lozzi

    sloan Guest

    I'd look more toward your code as the issue, before the artificial msde
    govenor.

    IDataReader's must be CLOSED.
    I repeat.
    IDataReaders' must be CLOSED.



    I'd look into using the DAAB 2.0 (sql server specific) or the
    EnterpriseLibrary (Data especially).
    They have already coded the best practices, so you don't have to remember
    to.


    If you're using ConnectionPooling, then you need to understand how it works,
    or you can get a billion connections opened.

    See
    ISBN 159059522X for a great discussion on this.


    typical code should look like this in the DataLayer.

    public void ReadSomeData(){


    IDataReader idr = null


    try{

    //do something here with the idr, like populate it, loop over it, etc ,etc


    }
    }finally{
    if (null!=idr)
    {
    idr.Close();
    }
    }
    }



    There is no catch statement, place your catch statement in the business
    layer or presentation layer.

    See
    http://blogs.msdn.com/brada/archive/2004/12/03/274718.aspx

    for a discussion on this.


    "David Lozzi" <> wrote in message
    news:...
    > Howdy!
    >
    > I have a question for all you smarties... I have a ASP.Net application
    > running on Windows 2000 Professional and MSDE, same box. While running the
    > application, users will randomly receive a too many connections error or
    > even a simple Page cannot be displayed. I know some of the limitations of
    > MSDE and have managed to fudge my way around them, but what about Win2kPro
    > IIS? I'm thinking it won't let me a host an active application on it? This
    > app will be seeing 20-30 users at any point. We do have a Win2k3 SQL 2000
    > server available but my customer wants to know for sure this is the

    issue...
    >
    > Thanks,
    >
    > --
    > D a v i d L o z z i
    > Data & Web Technology Specialist
    > Delphi Technology Solutions, Inc.
    > Wilmington, MA
    > dlozzi@(remove this)delphi-ts.com - www.delphi-ts.com
    >
    >
     
    sloan, May 16, 2006
    #2
    1. Advertising

  3. David Lozzi

    sloan Guest

    PS
    http://spaces.msn.com/sholliday/ 12/16/2005

    Check my blog... to see if you put in the correct settings on the install.

    This is a smaller issue, compared to the IDataReader issue.

    ...

    PPS

    SqlReader is one implementation of IDataReader, fyi.


    PPPS
    On a web environment, your data code's goals are:

    Open as late as possible
    Do Something, but only what you need
    CLOSE as SOON as possible.

    A website is a great candidate for MSDE .... IF you code correctly ,
    especially the dataaccess.




    "David Lozzi" <> wrote in message
    news:...
    > Howdy!
    >
    > I have a question for all you smarties... I have a ASP.Net application
    > running on Windows 2000 Professional and MSDE, same box. While running the
    > application, users will randomly receive a too many connections error or
    > even a simple Page cannot be displayed. I know some of the limitations of
    > MSDE and have managed to fudge my way around them, but what about Win2kPro
    > IIS? I'm thinking it won't let me a host an active application on it? This
    > app will be seeing 20-30 users at any point. We do have a Win2k3 SQL 2000
    > server available but my customer wants to know for sure this is the

    issue...
    >
    > Thanks,
    >
    > --
    > D a v i d L o z z i
    > Data & Web Technology Specialist
    > Delphi Technology Solutions, Inc.
    > Wilmington, MA
    > dlozzi@(remove this)delphi-ts.com - www.delphi-ts.com
    >
    >
     
    sloan, May 16, 2006
    #3
  4. David Lozzi

    Norman Yuan Guest

    BY "20-30 users at any point", do you mean they may access to the web app at
    the SAME time? If so, it is likely the host OS (Win2K Pro) problem, rather
    than MSDE. For MSDE, if there is more than 5 concurrent connection at the
    same time, the MSDE slows down due to the governer kicks in. In this case,
    the connection to MSDE may get timeout error. OTH, WIN2K Pro only allows
    maximum 10 connections. If you have more than 10 users to connection the
    WIN2K Pro box, whether they connect to IIS for web apps (with or without
    access to MSDE), or they connect to a shared folder, only 10 are allowed,
    and you get "too many connections" error if more than 10 users trying to
    connect to the machine. It is is this case, you have to go to a server OS,
    or go back to Win98 (no 10 connection limit built-in, but may be too old OS
    to go back).

    "David Lozzi" <> wrote in message
    news:...
    > Howdy!
    >
    > I have a question for all you smarties... I have a ASP.Net application
    > running on Windows 2000 Professional and MSDE, same box. While running the
    > application, users will randomly receive a too many connections error or
    > even a simple Page cannot be displayed. I know some of the limitations of
    > MSDE and have managed to fudge my way around them, but what about Win2kPro
    > IIS? I'm thinking it won't let me a host an active application on it? This
    > app will be seeing 20-30 users at any point. We do have a Win2k3 SQL 2000
    > server available but my customer wants to know for sure this is the
    > issue...
    >
    > Thanks,
    >
    > --
    > D a v i d L o z z i
    > Data & Web Technology Specialist
    > Delphi Technology Solutions, Inc.
    > Wilmington, MA
    > dlozzi@(remove this)delphi-ts.com - www.delphi-ts.com
    >
     
    Norman Yuan, May 16, 2006
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dave

    msde-2000

    Dave, Nov 6, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    582
    Mary Chipman
    Nov 8, 2004
  2. VB Programmer

    Re: Question: MSDE 2000 / Enterprise Manager

    VB Programmer, Aug 18, 2003, in forum: ASP .Net
    Replies:
    3
    Views:
    790
    VB Programmer
    Aug 18, 2003
  3. newgenre
    Replies:
    2
    Views:
    936
    Matt Berther
    Apr 19, 2004
  4. Wayne Erfling
    Replies:
    0
    Views:
    340
    Wayne Erfling
    Nov 18, 2006
  5. Nathan Sokalski
    Replies:
    5
    Views:
    204
    Jeff Cochran
    Dec 10, 2003
Loading...

Share This Page