SQL server problem or DB problem

[Tiffany]

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

[alberto]

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
>

[Kevin Downs]

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
>

[Tiffany]

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
>>
>
>

[Tiffany]

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
>>
>

[Tiffany]

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
>>
>
>

[Kevin Downs]

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
> >>
> >
> >
>