Re: Problem with OLE DB Provider

From: Miha Markic [MVP C#] (miha)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 11:10:23 +0100

Hi Pranav,

Huh, weird.
Do you close the connection after exporting? 

-- 
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
"Pranav Nabar" <psnabar@msn.com> wrote in message
news:eTwQQQ49DHA.2532@TK2MSFTNGP09.phx.gbl...
> Hi,
> I am working on an ASP.NET application. From a page, I am triggering
export
> of a large dataset into an Excel file using OLE DB Provider and after the
> export is complete the user is redirected to the excel file. Note that the
> operations here are synchronous. The problem is the data exported is not
> getting written out to the disk before the user is redirected. So I get an
> empty excel file in IE while if I check the actual file on the disk, the
> data seems to be there after a lag of a few seconds.
>
> From the KB article, I learnt I cannot set the Max Buffer Size property in
> OLE DB cannot be set in ADO.NET. How do I ensure that the data is flushed
to
> the disk before I redirect the user to the file?
>
> Thanks in advance,
> Pranav
>

Relevant Pages

  • Re: Exporting multiple files to a template instead of a new file!
    ... template file, export a query into that copy, repeat for each query to be ... As for exporting just to columns G and H, ... same name for the EXCEL file in each TransferSpreadsheet action step. ...
    (microsoft.public.access.externaldata)
  • Re: truncated text files in export
    ... Try exporting the Excel file to a text file. ... (LF alone or CR alone) ... >I am getting truncated reports when exporting them into text ...
    (microsoft.public.access.externaldata)
  • Re: recovering lost file
    ... > I get a message saying the disk is not formatted. ... Boot the computer with a bootable floppy. ... and insert the one containing your Excel file. ...
    (microsoft.public.windowsxp.newusers)
  • Re: help group rows after exporting report to Excel! :(
    ... If I copy the content on a new workbook, keeping the original source ... In the exported from Crystal reports Excel File it's impossible to ... After exporting Crystal report file in Excel, ...
    (microsoft.public.excel)
  • Excel File not opening after saving in 97/2000
    ... Then I opened the Excel file. ... No message window opened to ask me if I ... Should I have left it in 5.0/95 format? ... It seems as though exporting from Access into a 97/2000 ...
    (microsoft.public.excel.newusers)