Excel.Range.set_Value string length limitation [modified] - solved (kind of...) - COM Discussion Boards

Re: prblem with cocreateinstance ....!

9-Oct-06 1:43

This is not full code , ofcourse. Can you show it.
Just making sure, have you used, ::Coinitialize(NULL), before calling any COM function.

Prasad
Notifier using ATL | Operator new[],delete[][^]

Sakthiu9-Oct-06 1:51

Sakthiu

9-Oct-06 1:51

yes I used ....
hr=CoInitialize(NULL);
IProduct *pInface;

hr=CoCreateInstance(CLSID_Product,NULL,CLSCTX_INPROC_SERVER,IID_IProduct, (void**)&pInface);

if(SUCCEEDED(hr))
{
printf("Success COM inside");
pInface->Display(Str,RetStr);
}
CoUninitialize();

Re: prblem with cocreateinstance ....!

Lim Bio Liong9-Oct-06 4:09

Lim Bio Liong

9-Oct-06 4:09

Hello Sakthiu,

Aside from the fact that the third parameter to CoCreateInstance() is CLSCTX_INPROC_SERVER whareas your COM server is an EXE Server (the parameter value should be CLSCTX_LOCAL_SERVER), there are also many other possibilities (e.g. COM server not registered, proxy/client DLL not registered, etc).

It would also help tremendously if you let us know what the return value to CoCreateInstance() is (i.e. the value of "hr").

- Bio.

simulate draging a file (drag and drop)

drax_08158-Oct-06 20:53

drax_0815

8-Oct-06 20:53

I manually call an application that normally gets a file from
drag and drop and displays some information about it.

Now i'm able to call the application, but
how can I specifiy the dragged file by hand?

All I know is to implemet an IdataObject,
witch contains a STGMEDIUM, and a FORMATETC.

I know that the application witch recieves the file,
get's the information from the hGlobal member of the
stgmedium struct.

Can anybody help me with this problem?

If you want I can post my sourcecode, too.

Exception of com in web application

King Shez8-Oct-06 20:19

King Shez

8-Oct-06 20:19

HI
Guys in my application in crystal reports, the following exception arises some times :

System.Web System.Runtime.InteropServices.COMException (0x80004005): The process cannot access the file because it is being used by another process.
at
CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(Export
Options pExportOptions, RequestContext pRequestContext)
at
CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequ
estContext reqContext)
at
CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportReq
uestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.y(ExportOptions
1)
at
CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportF
ormatType formatType)

Can any one let me know the solution for this exception , plzzzzzz ASAP , thankx in advance.

Issues with COM-WOW64

indranil_m7-Oct-06 15:50

indranil_m

7-Oct-06 15:50

Hi,

I developed an out-of-proc (exe) Server which has both 32 and 64 bit versions.
I developed a client at 32 bit. But when I try to run that client on 64 bit, CoCreateInstance fails giving Class-Not-Registered. For WOW64 bit, I passed CLSCTX option as CLSCTX_ACTIVATE_64_BIT_SERVER. Still the CoCreateInstance failed.

1. How can I call 64 bit exe server from 32 bit client? MSDN says this can be done, but I am not able to do this.

2. If I want to support WOW64 from the server side, what changes do I need to do in the server side? Do I have to install both 32 and 64 bit version exe in the 64 bit OS to support WOW64? Do I need to make seperate regitry entries?

Many thanks in Advance for the help... Smile | :)

Excel.Range.set_Value string length limitation [modified] - solved (kind of...)

mikone6-Oct-06 1:36

mikone

6-Oct-06 1:36

Hey guys

My situation:

I started playing around with the excel object library in c# and became a bit confused when an error occured while trying to set the value of a specific range.

First I wanted to use a 2-dimensional array to fill the sheet with data in one step. But I had to break it down to more little parts (inserting row for row) in order to track down the source of this strange error.

When inserting row for row, i noticed some of them being inserted well and others were not.

The difference between the rows which were inserted without any error and those who weren't is the length of some strings which consist of more than 911 characters.
I already found out that inserting the single value into the cell works fine but as soon as i use an array to fill the sheet, it does not work anymore.

Now (and finally Wink | ;)

) my question:

Is there any way to fill a excel sheet with a 2-dimensional array which contains strings longer than 911 chars with the set_Value method of a range object?

And if not - do you know any kind of workaround except for truncating the string to 911 chars?

Google wasn't very helpful (or i did not search for the right subject) and i just found some fellows having the same problem without any solution...

Thanks in advance,
mik

//edit:
I spent some more time in searching for a solution and found the following knowledge base article:
You may receive a "Run-time error 1004" error message when you programmatically set a large array string to a range in Excel 2003

I really don't want to believe that this actually is THE workaround - i even think its not a workaround at all. I would be glad to see a real workaround for this problem...

//second edit:
After googling like i never did before i found a google group post where a nice guy describes how to read a adodb recordset and fill the excel sheet with its data by using a QueryTable object. You also can use this to parse (tab-seperated) textfiles.
Here's the link - just check out the MSDN documentation for the different classes if you dont understand something (though QueryTable Class is barely documented...) -
Fill a Excelsheet with a QueryTable to work around the 911 character limitation

-- modified at 10:44 Monday 9th October, 2006

New method problem

prasad_som5-Oct-06 5:00

5-Oct-06 5:00

I'd activex control, having certain set of functions. Recently, I've added a new function to it, which i intend to exposed,

BEGIN_DISPATCH_MAP(CMyCtrl, COleControl)
	//{{AFX_DISPATCH_MAP(CMyCtrl)
	DISP_FUNCTION(CMyCtrl, "fun1", fun1, VT_EMPTY, VTS_I4 VTS_I4)
	DISP_FUNCTION(CMyCtrl, "newfunction", newfunction, VT_EMPTY, VTS_VARIANT)
END_DISPATCH_MAP()

I use this control at client code, using COledispatchDriver.
But problem is, now call to new function throws exception. i.e. it doesn't recognizes new function. COledispatchDriver is not able to invoke newly added function. I've registed changed activex.

Does anybody faced similar problem?

Prasad
Notifier using ATL | Operator new[],delete[][^]

Roger Stoltz5-Oct-06 23:17

5-Oct-06 23:17

You have to re-import the ActiveX. Otherwise the classwizard generated wrapper class for your interface won't contain the new interface function.

By registering the component you simply add information to the registry, e.g. where the typelib for the component can be found. The registration procedure does not magically change any code in your client.

Of course you can "manually" add the new interface function to your client's interface wrapper class without re-importing the component. Have a look at how "funl" is handled and you should be able to figure it out. Just be careful to get the dispid and the argument list correct.

Hope this helps
--
Roger

"It's supposed to be hard, otherwise anybody could do it!" - selfquote

"No one remembers a coward!" - Jan Elfström 1998
"...but everyone remembers an idiot!" - my lawyer 2005 when heard of Jan's saying above

prasad_som5-Oct-06 23:26

5-Oct-06 23:26

Hi Roger,
I'm not importing ocx, as you mentioned.
I'm using Coledispatchdriver class instead. By some efforts, I found that, the problem occurs on m/c , having this activex installed previously(old version, without new function). In that case, after registration, new value named InprocServer32 (its not key), is stored under key InprocServer32. Which contains some garbage.
If I delete that value, it works fine Confused | :confused:

.
Still cant figure out problem.

thanks for your concern.

Prasad
Notifier using ATL | Operator new[],delete[][^]

Roger Stoltz5-Oct-06 23:59

5-Oct-06 23:59

Sorry Prasad, I cannot figure that one out. At least not right now.

But I must say I don't really get your problem... Unsure | :~

1. You have an older version of the ActiveX without the new function that works fine.
2. When you register the newer version it adds the InprocServer32 value below the InprocServer32 key and fills it with "garbage".
3. If you delete the InprocServer32 value, the new version works fine.

Is this correctly understood?

What happens if you unregister the previous version before registering the new?
Is the "garbage" a MULTI_SZ similar to the same value for the "Microsoft ProgressBar Control, version 6.0" (CLSID = {35053A22-8589-11D1-B16A-00C0F0283628})?
What happens if you change the contents of the InprocServer32 value instead of deleting it? Error messages when trying to create the server?

--
Roger

prasad_som6-Oct-06 0:11

6-Oct-06 0:11

Roger Stoltz wrote:
1. You have an older version of the ActiveX without the new function that works fine.
2. When you register the newer version it adds the InprocServer32 value below the InprocServer32 key and fills it with "garbage".
3. If you delete the InprocServer32 value, the new version works fine.

Is this correctly understood?

exactly.

Roger Stoltz wrote:
What happens if you unregister the previous version before registering the new?

No success.

Roger Stoltz wrote:
Is the "garbage" a MULTI_SZ similar to the same value for the "Microsoft ProgressBar Control, version 6.0" (CLSID = {35053A22-8589-11D1-B16A-00C0F0283628})?

yes, its similar to it.

Roger Stoltz wrote:
What happens if you change the contents of the InprocServer32 value instead of deleting it?

Haven't tried it. But , as mentioned earlier, deleting it was the solution( obviosly, cant ask user to do that Smile | :)

, i.e. to play registry).
I tried to access added function from activex control test container. I can see it in list. But again show no effect on pressing invoke. Same thing happen when tried to access new function in vb code. Intellisense shows added function. But in run , error comes, telling 'object doesn't support this property/method'.

thanks.

Prasad
Notifier using ATL | Operator new[],delete[][^]

Roger Stoltz6-Oct-06 2:29

6-Oct-06 2:29

The InprocServer32 key's default value is always the path to the library containing the server, but I haven't seen the value with the same name before.

So: I've google'd around trying to get some information about this mysterious InprocServer32 value.
It turns out that the most usual usage of this value is by installing the server with InstallShield and provides some kind of support for update service.
I have to dig deeper to get more out of it, but perhaps I don't have to...

Now to the obvious question: are you at some point using and/or registering InstallShield, or any external installer...? Or am I barking up the wrong tree?

--
Roger

prasad_som6-Oct-06 2:41

6-Oct-06 2:41

Roger Stoltz wrote:
are you at some point using and/or registering InstallShield, or any external installer...?

No I'm just using regsvr32 commandline.

Prasad
Notifier using ATL | Operator new[],delete[][^]

Roger Stoltz6-Oct-06 4:48

6-Oct-06 4:48

I found this[^] KB article at InstallShield's site.

It seems like it is the "Microsoft Windows Installer Service" that uses this registry value on "recent" platforms, i.e. w2k and later.
Since you're simply registering the server through command line, I suspect you're building the server with a MSVC version greater than 6.0 and the registration of this value is burried somewhere in the framework. Usually I'm working with MSVC6 so I'm not that familiar with later versions.

If you put a breakpoint inside the server's DllRegisterServer you should get to the code that registers this value...eventually.
Doesn't sound like much fun though. I think it would make sense if you could disable this feature somewhere in the call chain of DllRegisterServer.

BTW, are you able to call any other interface function of your server successfully?

--
Roger

prasad_som6-Oct-06 19:43

6-Oct-06 19:43

Thanks for information, Roger.

Prasad
Notifier using ATL | Operator new[],delete[][^]

prasad_som7-Oct-06 19:04

ATL property in OCX Control (MFC)

7-Oct-06 19:04

Roger Stoltz wrote:
BTW, are you able to call any other interface function of your server successfully?

--

Yes, I can call old server functions succesfully.

Prasad
Notifier using ATL | Operator new[],delete[][^]

Error tracing problem

Radu Sorin5-Oct-06 3:45

Radu Sorin

5-Oct-06 3:45

I have an application that uses COM+ and on some machines i get crashes ... The only error message is the standard windows error message and it gives me this
Faulting application application.exe, version 1.0.0.1, faulting module ole32.dll, version 5.1.2600.2726, fault address 0x00120f57.
Is there any way in which i can trace this address to a exported function in the ole32.dll to get an ideea what exported function is crashing?
Thanks .

AntonioKeh5-Oct-06 1:02

AntonioKeh

5-Oct-06 1:02

I have been trying to expose an ATL or class objects from an ActiveX control I have created using VC6 MFC.

Any Genius out there who have experience with this?

What I want is to have an ActiveX control "ControlX" what have a property "PropertyY" that is actually a class/ATL with methods and properties.

So If I am using VB6 to call a method in "PropertyY":
call ControlX.PropertyY.MethodZ

Any suggestions are welcome! Confused | :confused:

Problem in using com (not have .h file)

Manish_Home4-Oct-06 20:31

Manish_Home

4-Oct-06 20:31

Hi,
I have a already created COM Sniff | :^)

(.dll file only) which was used in c#.net code but i have to use it in C++ code Confused | :confused:

.
I dont have .h file for this COM,had only dll file.
Can Anyone help me in : How can i use this COM im my c++ code D'Oh! | :doh:

??
Thanx in advance Smile | :)

Manish

Steve S4-Oct-06 22:11

Steve S

4-Oct-06 22:11

You can use #import to get wrapper classes for the stuff implemented, providing that the DLL has a typelibrary embedded in it.

Steve S
Developer for hire

Manish_Home6-Oct-06 0:29

Manish_Home

6-Oct-06 0:29

Thanx Steve Smile | :)

Did u mean i should call getprocaddress on all functions i needed from that dll and make a wrapper around those functions...

Manish

prasad_som6-Oct-06 0:38

6-Oct-06 0:38

You need to use #import "yourdll.dll" statement in your code. Doing so, .tlh, and .tli will be generated in debug/release folder. You can use .tlh as header.

Prasad
Notifier using ATL | Operator new[],delete[][^]