ODBC Problem (urgent)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Thread: ODBC Problem (urgent)

  1. #1
    Ken Mui Guest

    ODBC Problem (urgent)


    I have a set of asp programs using ado to access foxpro 2.6 database for DOS.
    The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on the browser
    and the speed to display is fast, about 3 seconds to completely display all
    data. Notice that the database is in the PC runnning Windows 98.

    But when the set of asp programs are run under IIS 4.0/NT4, the speed to
    display data is very slow and not acceptable. Sometimes, the browser cannot
    display all data and timeout.
    This time the database is in the PC running NT.

    I guess that it is the problem of ODBC because it is responsible for connection
    between database and web server. I have checked several times that the setting
    of ODBC is the same between Windows 98 and NT.

    Can anyone help me? Do I guess right? If not, what is the problem and solution?


    Thanks a lot.

    Ken

  2. #2
    James Dooley Guest

    Re: ODBC Problem (urgent)

    -- Are you accessing IIS over a network? If so this may be some of the
    problem...

    -- Are there other users hitting the IIS server at the same time, this could
    also be a problem......

    Regards,

    James.

    "Ken Mui" <kenmui@willas-array.com> wrote in message
    news:39d3f19d$1@news.devx.com...
    >
    > I have a set of asp programs using ado to access foxpro 2.6 database for

    DOS.
    > The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on the

    browser
    > and the speed to display is fast, about 3 seconds to completely display

    all
    > data. Notice that the database is in the PC runnning Windows 98.
    >
    > But when the set of asp programs are run under IIS 4.0/NT4, the speed to
    > display data is very slow and not acceptable. Sometimes, the browser

    cannot
    > display all data and timeout.
    > This time the database is in the PC running NT.
    >
    > I guess that it is the problem of ODBC because it is responsible for

    connection
    > between database and web server. I have checked several times that the

    setting
    > of ODBC is the same between Windows 98 and NT.
    >
    > Can anyone help me? Do I guess right? If not, what is the problem and

    solution?
    >
    >
    > Thanks a lot.
    >
    > Ken




  3. #3
    kenmui Guest

    Re: ODBC Problem (urgent)


    Yes, IIS is accessed over a network and at the same time, there are more than
    one users access IIS. Could you please tell me what is the problems and the
    solutions?

    Thanks a lot.

    "James Dooley" <james@siteknowhow.com> wrote:
    >-- Are you accessing IIS over a network? If so this may be some of the
    >problem...
    >
    >-- Are there other users hitting the IIS server at the same time, this could
    >also be a problem......
    >
    >Regards,
    >
    >James.
    >
    >"Ken Mui" <kenmui@willas-array.com> wrote in message
    >news:39d3f19d$1@news.devx.com...
    >>
    >> I have a set of asp programs using ado to access foxpro 2.6 database for

    >DOS.
    >> The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on the

    >browser
    >> and the speed to display is fast, about 3 seconds to completely display

    >all
    >> data. Notice that the database is in the PC runnning Windows 98.
    >>
    >> But when the set of asp programs are run under IIS 4.0/NT4, the speed

    to
    >> display data is very slow and not acceptable. Sometimes, the browser

    >cannot
    >> display all data and timeout.
    >> This time the database is in the PC running NT.
    >>
    >> I guess that it is the problem of ODBC because it is responsible for

    >connection
    >> between database and web server. I have checked several times that the

    >setting
    >> of ODBC is the same between Windows 98 and NT.
    >>
    >> Can anyone help me? Do I guess right? If not, what is the problem and

    >solution?
    >>
    >>
    >> Thanks a lot.
    >>
    >> Ken

    >
    >



  4. #4
    James Dooley Guest

    Re: ODBC Problem (urgent)

    Hi There,

    - Connecting to an IIS server over the network is always going to be
    slower that a local connection, you're sharing the network with other
    users and other applications. You could try and do some analysis
    on the network and see if you can reduce over all traffic on the network
    (assuming that it's a LAN). Of course you could always upgrade the
    network if you've got the cash <g>.

    - The IIS server will naturally slow down when it has to serve more
    than one request. You could do some analysis on the server to see
    what it's up to and try to improve performance - adding some memory
    may help.

    In reality though I'd say you need to think about redesigning your
    application to handle the server and network bottlenecks. Think about
    these ideas:

    - Reduce that amount of records your shipping around, as a rule of thumb
    if your sending more than say 20 records to the client you should think of
    a new design.

    - Provide search facilities so the user can locate and download only the
    records they need.

    - If the data does not change to much think about generating the pages
    before hand with a background process.

    - Off load some of the processing on to a second server by changing your
    design to a Windows DNA one.

    "kenmui" <kenmui_2000@willas-array.com> wrote in message
    news:39d859ec$1@news.devx.com...
    >
    > Yes, IIS is accessed over a network and at the same time, there are more

    than
    > one users access IIS. Could you please tell me what is the problems and

    the
    > solutions?
    >
    > Thanks a lot.
    >
    > "James Dooley" <james@siteknowhow.com> wrote:
    > >-- Are you accessing IIS over a network? If so this may be some of the
    > >problem...
    > >
    > >-- Are there other users hitting the IIS server at the same time, this

    could
    > >also be a problem......
    > >
    > >Regards,
    > >
    > >James.
    > >
    > >"Ken Mui" <kenmui@willas-array.com> wrote in message
    > >news:39d3f19d$1@news.devx.com...
    > >>
    > >> I have a set of asp programs using ado to access foxpro 2.6 database

    for
    > >DOS.
    > >> The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on the

    > >browser
    > >> and the speed to display is fast, about 3 seconds to completely display

    > >all
    > >> data. Notice that the database is in the PC runnning Windows 98.
    > >>
    > >> But when the set of asp programs are run under IIS 4.0/NT4, the speed

    > to
    > >> display data is very slow and not acceptable. Sometimes, the browser

    > >cannot
    > >> display all data and timeout.
    > >> This time the database is in the PC running NT.
    > >>
    > >> I guess that it is the problem of ODBC because it is responsible for

    > >connection
    > >> between database and web server. I have checked several times that the

    > >setting
    > >> of ODBC is the same between Windows 98 and NT.
    > >>
    > >> Can anyone help me? Do I guess right? If not, what is the problem and

    > >solution?
    > >>
    > >>
    > >> Thanks a lot.
    > >>
    > >> Ken

    > >
    > >

    >




  5. #5
    James Dooley Guest

    Re: ODBC Problem (urgent)

    Hi There,

    Can you see my response from yesterday??? I can't seet it!

    James.

    "kenmui" <kenmui_2000@willas-array.com> wrote in message
    news:39d859ec$1@news.devx.com...
    >
    > Yes, IIS is accessed over a network and at the same time, there are more

    than
    > one users access IIS. Could you please tell me what is the problems and

    the
    > solutions?
    >
    > Thanks a lot.
    >
    > "James Dooley" <james@siteknowhow.com> wrote:
    > >-- Are you accessing IIS over a network? If so this may be some of the
    > >problem...
    > >
    > >-- Are there other users hitting the IIS server at the same time, this

    could
    > >also be a problem......
    > >
    > >Regards,
    > >
    > >James.
    > >
    > >"Ken Mui" <kenmui@willas-array.com> wrote in message
    > >news:39d3f19d$1@news.devx.com...
    > >>
    > >> I have a set of asp programs using ado to access foxpro 2.6 database

    for
    > >DOS.
    > >> The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on the

    > >browser
    > >> and the speed to display is fast, about 3 seconds to completely display

    > >all
    > >> data. Notice that the database is in the PC runnning Windows 98.
    > >>
    > >> But when the set of asp programs are run under IIS 4.0/NT4, the speed

    > to
    > >> display data is very slow and not acceptable. Sometimes, the browser

    > >cannot
    > >> display all data and timeout.
    > >> This time the database is in the PC running NT.
    > >>
    > >> I guess that it is the problem of ODBC because it is responsible for

    > >connection
    > >> between database and web server. I have checked several times that the

    > >setting
    > >> of ODBC is the same between Windows 98 and NT.
    > >>
    > >> Can anyone help me? Do I guess right? If not, what is the problem and

    > >solution?
    > >>
    > >>
    > >> Thanks a lot.
    > >>
    > >> Ken

    > >
    > >

    >




  6. #6
    Ken Mui Guest

    Re: ODBC Problem (urgent)


    Hi,
    I have read your useful message. Thanks a lot.

    "James Dooley" <james@siteknowhow.com> wrote:
    >Hi There,
    >
    >Can you see my response from yesterday??? I can't seet it!
    >
    >James.
    >
    >"kenmui" <kenmui_2000@willas-array.com> wrote in message
    >news:39d859ec$1@news.devx.com...
    >>
    >> Yes, IIS is accessed over a network and at the same time, there are more

    >than
    >> one users access IIS. Could you please tell me what is the problems and

    >the
    >> solutions?
    >>
    >> Thanks a lot.
    >>
    >> "James Dooley" <james@siteknowhow.com> wrote:
    >> >-- Are you accessing IIS over a network? If so this may be some of the
    >> >problem...
    >> >
    >> >-- Are there other users hitting the IIS server at the same time, this

    >could
    >> >also be a problem......
    >> >
    >> >Regards,
    >> >
    >> >James.
    >> >
    >> >"Ken Mui" <kenmui@willas-array.com> wrote in message
    >> >news:39d3f19d$1@news.devx.com...
    >> >>
    >> >> I have a set of asp programs using ado to access foxpro 2.6 database

    >for
    >> >DOS.
    >> >> The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on

    the
    >> >browser
    >> >> and the speed to display is fast, about 3 seconds to completely display
    >> >all
    >> >> data. Notice that the database is in the PC runnning Windows 98.
    >> >>
    >> >> But when the set of asp programs are run under IIS 4.0/NT4, the speed

    >> to
    >> >> display data is very slow and not acceptable. Sometimes, the browser
    >> >cannot
    >> >> display all data and timeout.
    >> >> This time the database is in the PC running NT.
    >> >>
    >> >> I guess that it is the problem of ODBC because it is responsible for
    >> >connection
    >> >> between database and web server. I have checked several times that

    the
    >> >setting
    >> >> of ODBC is the same between Windows 98 and NT.
    >> >>
    >> >> Can anyone help me? Do I guess right? If not, what is the problem and
    >> >solution?
    >> >>
    >> >>
    >> >> Thanks a lot.
    >> >>
    >> >> Ken
    >> >
    >> >

    >>

    >
    >



  7. #7
    Lou Guest

    Re: ODBC Problem (urgent)


    One speed up is on this web site, switch to a
    connection string:

    http://www.inquiry.com/techtips/asp_pro/top10/tip1.asp



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center