Unspecified error '80004005'

[MY Cheng]

Hi ,

Please help!!!!!

I got the same problem as well....... I encounter the problem when I upload a large excel file(more than 5000 records) to sql database using ASP page...... But it worked fine if the excel file is small(less than 1000 records......Everytime I got this error, I found it stopped at the command to open recordset.......


and got the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Unspecified error

/cddev/Lib/CDUtil.asp, line 3212

I guess it is something related to timeout. Why I say so? Actually, for the whole upload process, I am using a single database connection object. And I found that the problem is relieved if I restart the database connection after reading a certain numbers of records(say 700 rec). However, it is not a temporary workaround.

Here, I would like to give some more information about the configuration:
I am using SQL Server 200, ASP....

Below is the connection string I am using:
"PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=localhost;DATABASE=CDLive;UID=smait ;PWD=smait;"

Actually, I am not sure how I should fix the problem. Is there anyone could give me some advice? Is there any configuration I need to do like timeout value for connection can be modified so as to get rid of the problem?


Many Thanks
Irene

"Aaron [SQL Server MVP]" wrote:

> [url]http://www.aspfaq.com/2142[/url]
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>
>
>
> "3legs" <3legs@askme.com> wrote in message
> news:uLwn6YdUEHA.2908@TK2MSFTNGP10.phx.gbl...

> > When openning the database, sometimes (yes, not always) it gives the

> error:

> > "Unspecified error". How could I trace what the problem was?
> >
> >
> >

>
>
>

[Jeff Cochran]

On Tue, 15 Jun 2004 20:28:01 -0700, "MY Cheng" <MY
[email]Cheng@discussions.microsoft.com[/email]> wrote:

>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
>Unspecified error
>
>/cddev/Lib/CDUtil.asp, line 3212
>
>I guess it is something related to timeout. Why I say so? Actually, for the whole upload process, I am using a single database connection object. And I found that the problem is relieved if I restart the database connection after reading a certain numbers of records(say 700 rec). However, it is not a temporary workaround.

Still might look at the FAQ referenced if you haven't yet.

>Below is the connection string I am using:
> "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=localhost;DATABASE=CDLive;UID=***** ;PWD=*****;"

It's not generally smart to post a user ID and password in a public
newsgroup. :)

>Actually, I am not sure how I should fix the problem. Is there anyone could give me some advice? Is there any configuration I need to do like timeout value for connection can be modified so as to get rid of the problem?

Perhaps. A smarter solution would be to limit the number of records
returned by your query, use indexes to optimize the query and
otherwise streamline the code.

Jeff

>Many Thanks
>Irene
>
>"Aaron [SQL Server MVP]" wrote:
>

>> [url]http://www.aspfaq.com/2142[/url]
>>
>> --
>> [url]http://www.aspfaq.com/[/url]
>> (Reverse address to reply.)
>>
>>
>>
>>
>> "3legs" <3legs@askme.com> wrote in message
>> news:uLwn6YdUEHA.2908@TK2MSFTNGP10.phx.gbl...

>> > When openning the database, sometimes (yes, not always) it gives the

>> error:

>> > "Unspecified error". How could I trace what the problem was?
>> >
>> >
>> >

>>
>>
>>