Connection Closed Slowly (Around 1 min)

From: Stan the Mouse (StantheMouse_at_discussions.microsoft.com)
Date: 10/30/04


Date: Fri, 29 Oct 2004 22:16:03 -0700

I have amended the code, and it finally writes into my excel file. But the
time for closing the connection seems very slow, why? it there anyway to
shorten it down?

If I refresh my counter too faster (e.g. 10s), error will be shown:

Provider (0x80004005)
/asp/counter1/test0-gcount.asp, line 7

can anyone help me, please?

http://stanleychan.myftp.org/asp/counter1/test0-gcount.asp
http://stanleychan.myftp.org/asp/counter1/counter.xls
The code
http://stanleychan.myftp.org/asp/counter1/test0-gcount.txt

Many Many thanks



Relevant Pages

  • RE: Issue in Refreshing Excel Report Dataconnection
    ... I have a connection file in the trusted data connection library, ... refresh and chokes, giving me the message you got. ... To display this report in EWA webpart, i uploaded the Excel file into ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: OpenDataSource Was Working, Now Isnt
    ... Connection argument. ... > We're missing a key piece of information: strDataSourceName ... I had code that saves the document path as a document ... >> do to fix it to link to the Excel file and the worksheet with my data? ...
    (microsoft.public.word.mailmerge.fields)
  • Re: sql 2005 ssis- excel connection error
    ... I am looping through excel files to import data into a sql server table. ... Can not acquire connection from connection manager. ... So when I ruun the ssis package I get this error: ... the Excel file connection to a valid Excel file so that it can set the ...
    (microsoft.public.sqlserver.dts)
  • Re: Read Chinese character from excel using asp
    ... >I use asp to develop a web page to read an excel file containing Chinese>Character then display it in the web page. ... Unfortunately, I cant display>it!!! ... Response.CharSet = "utf-8"> ... > 'response.write connection ...
    (microsoft.public.inetserver.asp.general)
  • Re: Why Would ResponseStream().Read return zero bytes when not at end of file?
    ... there is no network requirement that the number of bytes delivered by the server before closing the connection is identical to the number of bytes the server advertised in the HTTP response. ... The advertised length is just that: an advertisement. ...
    (microsoft.public.dotnet.languages.csharp)