|
Yaki_15 wrote: Problems start to arise,
What problems, exactly?
0. Have you enabled DCOM on both machines?
1. Have you registered your DCOM service on the remote machine?
2. Have you checked that the access/launch permissions are correct on both machines?
3. Have you checked that the client is configured to talk to the server?
Supplementary questions;
What identity is your service launched as?
What identity is your client launched as?
Have you used explicit security (security blanket) or are you using DCOM registry settings?
Steve S
Developer for hire
|
|
|
|
|
Steve S wrote: 0. Have you enabled DCOM on both machines?
1. Have you registered your DCOM service on the remote machine?
2. Have you checked that the access/launch permissions are correct on both machines?
3. Have you checked that the client is configured to talk to the server?
Supplementary questions;
What identity is your service launched as?
What identity is your client launched as?
Have you used explicit security (security blanket) or are you using DCOM registry settings?
Firstof all, Thanks aton for your advising questions. Aatually I didn't kown
to install a DCOM shuould take so "many"(i use many 'cause each is to much for me to crack through) essentials into consideration. To tell your the true, i am a beginer with DCOM, I've just finished serval key and basic cousres on COM subject,such as COM Principle, IDL , Objcet Module... those courses discuss little on the issues you put forward. anyway, your reply does help alot to me, at least it let me know where i am on the way to succeed in DCOM. Maybe before i start to compose a Service, i need to load up
some knowledge about NT Security,right? I wander if you can advise me some helpful books or Website on this subject. 
|
|
|
|
|
Steve S wrote: What identity is your service launched as?
What identity is your client launched as?
Have you used explicit security (security blanket) or are you using DCOM registry settings?
Steve S wrote: 0. Have you enabled DCOM on both machines?
i don't know how to enable DCOM.
Steve S wrote: 1. Have you registered your DCOM service on the remote machine?
i am sure i have done this step.
Steve S wrote: 2. Have you checked that the access/launch permissions are correct on both machines?
how to do this?
Steve S wrote: 3. Have you checked that the client is configured to talk to the server?
can i do this by using stucture COSERVERINFO AND COATHNINFO?
as to the Supplementary questions, i think i still need your help.
|
|
|
|
|
0. Enable DCOM
OS specific. For XP, you run dcomcnfg from the command line or the 'Run...' prompt. In the tree in the left pane, expand component services, then computers.
Right-click 'My Computer' in list (probably only entry) and select properties.
In 'Default properties' tick 'Enable Distributed COM on this computer'.
2. In DCOMCNFG, under 'My Computer' (see above), there's a 'DCOM Config' option.
This lists apps which are registered. (You need entries on the client for this too) and you can set permissions and locations.
Q: Are you using explicit location by specifying COSERVERINFO etc at launch time, or using DCOM 'default' settings (from the registry/DCOMCNFG)?
Q: If you're running XPSP2, is the firewall running?
With a f/w, you have to tell DCOM which ports to use, and punch the appropriate holes in the firewall.
Steve S
Developer for hire
|
|
|
|
|
Steve S wrote: Q: Are you using explicit location by specifying COSERVERINFO etc at launch time, or using DCOM 'default' settings (from the registry/DCOMCNFG)?
i am using explicit location by specifying COSERVERINFO etc at launch time,
i have already shut down firewall for both local and remote machine which are
both running xpsp2.
|
|
|
|
|
they can work now. thank you, Steve S
|
|
|
|
|
See here[^] maybe it is some helpful to you
|
|
|
|
|
Here i am developing a application which require to fetch Time from database . But i am getting 00:00:00 AM as a time everytime. We are using MySql database.
Code fragment is....
========================================================
_variant_t vtValue;
vtValue = RsSession->Fields->GetItem("StartTime")->GetValue();
COleDateTime d( vtValue );
sprintf( name, "%02d:%02d:%02d",d.GetHour(),d.GetMinute(),d.GetSecond() );
========================================================
in "name" i am getting "00:00:00" ..everytime.. All the other values i am retrieving from ResultSetPtr are OK.
Can any one tell me what is to be done ther ....
Thanks in advance
Prafulla Vedante
E-Mail : prafulla_v@asianitg.com
|
|
|
|
|
This is what I use:
COleDateTime timField;
_variant_t varValue;
varValue.Clear();
varValue = m_pRecordset->Fields->GetItem(strFieldName)->GetValue();
if ( varValue.vt == VT_DATE ) //lint !e1036 !e569
{
timField.m_dt = varValue.date;
timField.SetStatus(COleDateTime::valid);
}
else
timField.SetStatus(COleDateTime::null);
|
|
|
|
|
sorry jerry but it doesent work at my side
it still gives me 00:00:00 .
Data type of "StartTime" in database is "time"
Prafulla Vedante
|
|
|
|
|
Hi guys
We are working in ASP.Net Environment and most of the time we are facing 1 problem as follows
I have 1 aspx page, in that i have 2 frames now in the sacond frame i have "main.aspx" page is running in that i have Logoff button on click of that i want to redirect to Home.aspx page but if i use Response.Redirect("Home.aspx") then my Home page gets open in the second frame and my 1st frame that is my top frame remain as it is
So what i want is like when we use hyperlinks then we specify the nevigate page and then the target (where to open this link)
Eg: Navigate Page = "Home.aspx"
Target = "_parent"
then it get open that Home page in the browser.
So can we do the same kind of thing in the ASP.Net by using Response.Redirect
Please help me guys
Regards,
Harshad Pednekar
|
|
|
|
|
In an asp.net application, I use a COM object... this COM objects is stored in the session.
The COM object has methods that can last a long time (it sends info through a socket and wait for the reply). My problem is whenever I call a method of the COM object, it is always in the same thread which means that multiple users can block themselves out ( I know: I log the thread ID).
The COM threading model is apartment.... which should be OK.
All threads in asp.net are MTA.... which should be OK.
But the whole thing is not OK.. any idea? Thanks!
|
|
|
|
|
Hello BadJerry,
Although all threads in asp.net are MTA-based, your COM object remains an STA object. Hence at runtime, when your COM object is created, an STA apartment will be created (whose thread is the one for which you have tracked the ID) and the COM object will live there.
If your have the source codes for your COM object, you can change the apartment type to MTA but you must of course modify your code to make it suitable as an MTA object (using CRITICAL_SECTION objects, etc).
If you do not have the source codes to the COM object, I suggest creating an MTA object that exposes the same interface but internally aggregates all interface method calls to the original COM object. This should allow the asp.net client to make calls to other methods while the long time-consuming method is underway.
Hope the above helps,
Bio.
|
|
|
|
|
The above really helped... I thought the apartment threading model was MTA and it was STA... It took a bit of time to move my object to MTA... changing a #define, the inheritance from the com objects and the .rgs file but it is all done and it now works!
There was also the fact that AfxGetThrread()->m_nThreadID was incorrect which threw me but in the end, it works!
Thanks again for taking the time to write your message!
Bad(StillButABitBetter)Jerry
|
|
|
|
|
Hello BadJerry,
I'm really glad that things worked out 
Best Regards,
Bio.
|
|
|
|
|
Hi all,
I'm trying to write comments in a cell using Automation for Excel 2003. I imported the all Excel Interfaces via VS .NET 2003. All interfaces for excel are based on COleDispatchDriver. I've caught the COleDispatchException but no error description was given. CCOleDispatchException.m_sc = -2146827284.
Ex:
//code has been reduced to bare minimum
//assume all necessary code has been created
CString myCommentText( "Making a statement" );
CRange cell( CWorksheet.get_Range( COleVariant("A1"),COleVariant("A1") ) );
VARIANT comment;
VariantInit( &comment );
comment.vt = VT_BSTR;
comment.bstrVal = myCommentText.AllocSysString();
//error occurs here
//when excel file is viewed, all comments written to it are there
//however the exception occurs when calling the function
cell.AddComment( comment );
SysFreeString( comment.bstrVal );
VariantClear( &comment );
Thank in advance
|
|
|
|
|
I get the same error from VBA. Can't you just trap the error, and if it's 1004, ignore it ?
Steve S
Developer for hire
|
|
|
|
|
I thought about that but I really want to know what is causing it. Besides I don't want to overlook something which may crash the app if left unchecked.
|
|
|
|
|
Currently I've found the solution. Instead of using AddComment, I'll begin using NoteText.
Returns or sets the cell note associated with the cell in the upper-left corner of the range. Read/write String.
Cell notes have been replaced by range comments. For more information, see the Comment object.
CRange .NoteText(Text, Start, Length)
expression Required. An expression that returns a Range object.
Text Optional Variant. The text to add to the note (up to 255 characters). The text is inserted starting at position Start, replacing Length characters of the existing note. If this argument is omitted, this method returns the current text of the note starting at position Start, for Length characters.
Start Optional Variant. The starting position for the text that's set or returned. If this argument is omitted, this method starts at the first character. To append text to the note, specify a number larger than the number of characters in the existing note.
Length Optional Variant. The number of characters to be set or returned. If this argument is omitted, Microsoft Excel sets or returns characters from the starting position to the end of the note (up to 255 characters). If there are more than 255 characters from Start to the end of the note, this method returns only 255 characters.
|
|
|
|
|
i wanna contruct a safearray,which is made up of VARIANT type element,which vt = VT_BSTR;i use SafeArrayCreate to create the safearray,then use SafeArrayPutElement to add element into array one by one,it's ok,and (this is just my test code) if i use SafeArrayGetElement to get the element that just now put into the array,on the neck of the SafeArrayPutElement at the same cycle statement,it's all right.
but if i write the SafeArrayGetElement out of the same cycle,the program
crashed.why?it's so strange.
my codes are as follows:
VARIANT *pvarCis = new VARIANT[nCount];
for(int i = 0;i < nCount;i++)
{
CComBSTR bstrCi(arCi.GetAt(i));
(pvarCis + i)->vt = VT_BSTR;
(pvarCis + i)->bstrVal = bstrCi.Copy();
}
SAFEARRAYBOUND rgsabound[1];
rgsabound[0].lLbound = 0;
rgsabound[0].cElements = nCount;
SAFEARRAY * psa = NULL;
psa = SafeArrayCreate(VT_VARIANT, 1, rgsabound);
if(psa)
{
psa->cbElements = nCount;
VARIANT *pvarCellInfo = new VARIANT[nCount];
HRESULT hresult;
for(long lIndex = 0; lIndex < nCount; lIndex++)
{
hresult = SafeArrayPutElement(psa,&lIndex,&pvarCis[lIndex]);
if(FAILED(hresult))
return;
hresult = SafeArrayGetElement(psa,&lIndex,&pvarCellInfo[lIndex]);
if(FAILED(hresult))
return;
}
for(lIndex = 0;lIndex < nCount; lIndex++)
{
hresult = SafeArrayGetElement(psa,&lIndex,&pvarCellInfo[lIndex]);
if(FAILED(hresult))
return;
}
... ...
}
|
|
|
|
|
cbElements must equal the size of an element of the array. Try with:
psa->cbElements = sizeof(<code>VARIANT</code>);
"no xe tuto oro quel che luse"
rechi+
|
|
|
|
|
Hello XPointer,
I tried your sample source code and discovered that the error lies around the following lines :
if(psa)
{
//psa->fFeatures = FADF_VARIANT;
psa->cbElements = nCount; // <-- should not set cbElements.
...
...
...
The "cbElements" field is already set when you called the SafeArrayCreate() function earlier :
psa = SafeArrayCreate(VT_VARIANT, 1, rgsabound);
Furthermore, this field indicates the size of each element of the array and since the element type has been declared to be VT_VARIANT, "cbElements" should be sizeof(VARIANT), i.e. 16 bytes, and should not be "nCount".
However the fields of the SAFEARRAY struct (including fFeatures) should all be transparent to developers and should only be accessed via APIs and not modified or accessed individually.
I suggest commenting out the line :
psa->cbElements = nCount;
Your code should work fine thereafter.
Best Regards,
Bio.
|
|
|
|
|
Hope this helps.. this creates a variant made of a safe array of variant which themselves are strings!
Just ignore the last 3 lines of code!
void CVariantTools::ToVariant(VARIANT & var,const CStringArray & arrColumns)
{
// Create the array
SAFEARRAYBOUND rgsabound[1];
rgsabound[0].lLbound = 0;
rgsabound[0].cElements = arrColumns.GetSize();
SAFEARRAY FAR* pArrayCol = SafeArrayCreate(VT_VARIANT, 1, rgsabound);
// Fill it with the column property
for ( int nCol=0; nCol < arrColumns.GetSize(); nCol++)
{
long rgIndice=nCol;
COleVariant oleValue(arrColumns.GetAt(nCol),VT_BSTR);
SafeArrayPutElement(pArrayCol,&rgIndice,&oleValue);
}
// Prepare the variants
VariantClear(&var);
var.vt=VT_ARRAY|VT_VARIANT;
var.parray = pArrayCol;
}
|
|
|
|
|
thanks Bogdan Rechi, Lim Bio Liong and BadJerry ,
now i complete my src according to your advice,thanks.
btw,i just considerred 'the Size of an element' to 'the number of elements' by mistake,so the error occurred certainly.it's my carelessness
thanks a lot!!!
|
|
|
|
|
Hi guys,
I've got a ASP .Net application which uses a COM object. I've turned on impersonation and assigned a valid windows user. The system.security.principle.windowsidentity.getcurrent.name property correctly returns the logon user.
However, the COM is still running under the ASPNET identity. I know this because I've added a function in the COM object to return the current user(win32 API).
How do I overcome this problem? The COM object needs to run under a non ASPNET account in order for it to access another server.
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
