SQL server problem or DB problem


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Thread: SQL server problem or DB problem

  1. #1
    Tiffany Guest

    SQL server problem or DB problem


    I work on SQL server 7.0 and i need to update a larger data in SQL sever (connect
    to WebSite) . After I completed updating, I receive error message in the
    web site.

    Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
    [Microsoft][ODBC SQL Server Driver]Timeout expired
    /music/album.asp, line 86

    I checked path music/album.asp still ok.
    Have anybody see this error message, please help me out?
    Best Wish
    Tiff


  2. #2
    alberto Guest

    Re: SQL server problem or DB problem


    check to see that on the web server you have an ODBC Connection ?

    "Tiffany" <tu@cubico.com> wrote:
    >
    >I work on SQL server 7.0 and i need to update a larger data in SQL sever

    (connect
    >to WebSite) . After I completed updating, I receive error message in the
    >web site.
    >
    >Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
    > [Microsoft][ODBC SQL Server Driver]Timeout expired
    > /music/album.asp, line 86
    >
    >I checked path music/album.asp still ok.
    >Have anybody see this error message, please help me out?
    >Best Wish
    >Tiff
    >



  3. #3
    Kevin Downs Guest

    Re: SQL server problem or DB problem

    Tiffany,

    There could be several different problems here. I assume that the
    update went ok. I also assume that the error you are receiving occurs
    when you attempt to inquire on that updated data.

    The problem occurs when the request for data takes to long to retrieve
    from the database. Run the SQL Server Profiler to get the SQL that the
    page is requesting. Then cut & paste this SQL into the query analyser.

    From here, you can try running the query to see how long it would have
    taken. If the query takes an unacceptable amount of time, look at the
    execution plan. The query may be need to be changed or the db may
    require an index to get better performance.

    I note that you are using the generic OLE ODBC driver in your asp
    page. I would advise, if at all possible, that you change to using the
    native OLE driver for SQL Server. This has better performance, and is
    more stable. You choice to change may be determined by the tools used
    to create the asp pages (What are you using?) - If you need details on
    this, I can give them.

    --
    Regards,
    Kevin


    "Tiffany" <tu@cubico.com> wrote in message
    news:3a5a55b5$1@news.devx.com...
    >
    > I work on SQL server 7.0 and i need to update a larger data in SQL

    sever (connect
    > to WebSite) . After I completed updating, I receive error message

    in the
    > web site.
    >
    > Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
    > [Microsoft][ODBC SQL Server Driver]Timeout expired
    > /music/album.asp, line 86
    >
    > I checked path music/album.asp still ok.
    > Have anybody see this error message, please help me out?
    > Best Wish
    > Tiff
    >




  4. #4
    Tiffany Guest

    Re: SQL server problem or DB problem


    Yes Kevin, May you give me some more detail about it?
    I check my query into the query analyst. It taks too long to process resolve.
    I want to change my query like your recommend but I am still confuse what
    i should do to change query?
    I am very new in SQL server !!!!!!!!!!!!!!
    Thanks

    "Kevin Downs" <kdowns@optushome.com.au> wrote:
    >Tiffany,
    >
    >There could be several different problems here. I assume that the
    >update went ok. I also assume that the error you are receiving occurs
    >when you attempt to inquire on that updated data.
    >
    >The problem occurs when the request for data takes to long to retrieve
    >from the database. Run the SQL Server Profiler to get the SQL that the
    >page is requesting. Then cut & paste this SQL into the query analyser.
    >
    >From here, you can try running the query to see how long it would have
    >taken. If the query takes an unacceptable amount of time, look at the
    >execution plan. The query may be need to be changed or the db may
    >require an index to get better performance.
    >
    >I note that you are using the generic OLE ODBC driver in your asp
    >page. I would advise, if at all possible, that you change to using the
    >native OLE driver for SQL Server. This has better performance, and is
    >more stable. You choice to change may be determined by the tools used
    >to create the asp pages (What are you using?) - If you need details on
    >this, I can give them.
    >
    >--
    >Regards,
    >Kevin
    >
    >
    >"Tiffany" <tu@cubico.com> wrote in message
    >news:3a5a55b5$1@news.devx.com...
    >>
    >> I work on SQL server 7.0 and i need to update a larger data in SQL

    >sever (connect
    >> to WebSite) . After I completed updating, I receive error message

    >in the
    >> web site.
    >>
    >> Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
    >> [Microsoft][ODBC SQL Server Driver]Timeout expired
    >> /music/album.asp, line 86
    >>
    >> I checked path music/album.asp still ok.
    >> Have anybody see this error message, please help me out?
    >> Best Wish
    >> Tiff
    >>

    >
    >



  5. #5
    Tiffany Guest

    Re: SQL server problem or DB problem


    I check web server and ODBC's connect.

    "alberto" <albert77@rocketmail.com> wrote:
    >
    >check to see that on the web server you have an ODBC Connection ?
    >
    >"Tiffany" <tu@cubico.com> wrote:
    >>
    >>I work on SQL server 7.0 and i need to update a larger data in SQL sever

    >(connect
    >>to WebSite) . After I completed updating, I receive error message in the
    >>web site.
    >>
    >>Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
    >> [Microsoft][ODBC SQL Server Driver]Timeout expired
    >> /music/album.asp, line 86
    >>
    >>I checked path music/album.asp still ok.
    >>Have anybody see this error message, please help me out?
    >>Best Wish
    >>Tiff
    >>

    >



  6. #6
    Tiffany Guest

    Re: SQL server problem or DB problem


    Yes Kevin, May you give me some more detail about it?
    I check my query into the query analyst. It taks too long to process resolve.
    I want to change my query like your recommend but I am still confuse what
    i should do to change query?
    I am very new in SQL server !!!!!!!!!!!!!!
    Thanks


    "Kevin Downs" <kdowns@optushome.com.au> wrote:
    >Tiffany,
    >
    >There could be several different problems here. I assume that the
    >update went ok. I also assume that the error you are receiving occurs
    >when you attempt to inquire on that updated data.
    >
    >The problem occurs when the request for data takes to long to retrieve
    >from the database. Run the SQL Server Profiler to get the SQL that the
    >page is requesting. Then cut & paste this SQL into the query analyser.
    >
    >From here, you can try running the query to see how long it would have
    >taken. If the query takes an unacceptable amount of time, look at the
    >execution plan. The query may be need to be changed or the db may
    >require an index to get better performance.
    >
    >I note that you are using the generic OLE ODBC driver in your asp
    >page. I would advise, if at all possible, that you change to using the
    >native OLE driver for SQL Server. This has better performance, and is
    >more stable. You choice to change may be determined by the tools used
    >to create the asp pages (What are you using?) - If you need details on
    >this, I can give them.
    >
    >--
    >Regards,
    >Kevin
    >
    >
    >"Tiffany" <tu@cubico.com> wrote in message
    >news:3a5a55b5$1@news.devx.com...
    >>
    >> I work on SQL server 7.0 and i need to update a larger data in SQL

    >sever (connect
    >> to WebSite) . After I completed updating, I receive error message

    >in the
    >> web site.
    >>
    >> Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
    >> [Microsoft][ODBC SQL Server Driver]Timeout expired
    >> /music/album.asp, line 86
    >>
    >> I checked path music/album.asp still ok.
    >> Have anybody see this error message, please help me out?
    >> Best Wish
    >> Tiff
    >>

    >
    >



  7. #7
    Kevin Downs Guest

    Re: SQL server problem or DB problem

    I have replied to Tiffany privately - the info needed would result in
    very large postings...
    and public NG is probably not a good place to post details of the
    internals of a public website

    I'll post the resolution here later.
    --
    Regards,
    Kevin

    "Tiffany" <tu@cubico.com> wrote in message
    news:3a5b9a9d$1@news.devx.com...
    >
    > Yes Kevin, May you give me some more detail about it?
    > I check my query into the query analyst. It taks too long to

    process resolve.
    > I want to change my query like your recommend but I am still

    confuse what
    > i should do to change query?
    > I am very new in SQL server !!!!!!!!!!!!!!
    > Thanks
    >
    >
    > "Kevin Downs" <kdowns@optushome.com.au> wrote:
    > >Tiffany,
    > >
    > >There could be several different problems here. I assume that the
    > >update went ok. I also assume that the error you are receiving

    occurs
    > >when you attempt to inquire on that updated data.
    > >
    > >The problem occurs when the request for data takes to long to

    retrieve
    > >from the database. Run the SQL Server Profiler to get the SQL that

    the
    > >page is requesting. Then cut & paste this SQL into the query

    analyser.
    > >
    > >From here, you can try running the query to see how long it would

    have
    > >taken. If the query takes an unacceptable amount of time, look at

    the
    > >execution plan. The query may be need to be changed or the db may
    > >require an index to get better performance.
    > >
    > >I note that you are using the generic OLE ODBC driver in your asp
    > >page. I would advise, if at all possible, that you change to using

    the
    > >native OLE driver for SQL Server. This has better performance, and

    is
    > >more stable. You choice to change may be determined by the tools

    used
    > >to create the asp pages (What are you using?) - If you need details

    on
    > >this, I can give them.
    > >
    > >--
    > >Regards,
    > >Kevin
    > >
    > >
    > >"Tiffany" <tu@cubico.com> wrote in message
    > >news:3a5a55b5$1@news.devx.com...
    > >>
    > >> I work on SQL server 7.0 and i need to update a larger data in

    SQL
    > >sever (connect
    > >> to WebSite) . After I completed updating, I receive error

    message
    > >in the
    > >> web site.
    > >>
    > >> Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
    > >> [Microsoft][ODBC SQL Server Driver]Timeout expired
    > >> /music/album.asp, line 86
    > >>
    > >> I checked path music/album.asp still ok.
    > >> Have anybody see this error message, please help me out?
    > >> Best Wish
    > >> Tiff
    > >>

    > >
    > >

    >




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