PC Review


Reply
Thread Tools Rate Thread

How copy the contents of an ADO recordset object onto Excel worksh

 
 
Vitalijs
Guest
Posts: n/a
 
      6th Jan 2009
I' m using VB.NET 2008, VSTO 2.0, Framwork 2.0 and .Net Remoting.
when I call the function CopyFromRecordset for my recordset I get an error:

System.OutOfMemoryException: Type 'ADODB.InternalFields' in Assembly 'ADODB,
Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' is not
marked as serializable. Server stack trace: Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg) at
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData,
Int32 type) at
Microsoft.Office.Interop.Excel.Range.CopyFromRecordset(Object Data, Object
MaxRows, Object MaxColumns) at
ExcelWorkbook2.XlsAtskaite.CreateRange(Object oRange, String
spClassAndMethodName, Object opArgs) in MYCODE.vb.


When I was using VB.NET 2003, vsto 1.0 and COM+ function have worked
perfectly.

Any ideas?
Thanks.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy data that matches criteria in one worksheet to another worksh angiec50 Microsoft Excel Worksheet Functions 1 7th Oct 2009 01:49 PM
Search data w. use of msg box and copy results to new blanc worksh Basta1980 Microsoft Excel Programming 2 11th Sep 2008 12:45 PM
Copy all contents of a recordset to clipboard =?Utf-8?B?TWlrZQ==?= Microsoft Access Form Coding 6 10th Jan 2007 08:44 PM
Excel 2000 Visual Basic - Export Contents of ListBox into a worksh =?Utf-8?B?TGlnYXlh?= Microsoft Excel Programming 7 2nd Nov 2004 03:58 PM
copy recordset to Excel Workbook =?Utf-8?B?QmF6?= Microsoft Access VBA Modules 7 19th Jan 2004 07:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:01 AM.