COM Discussion Boards

Dyrl20-Feb-06 7:13

20-Feb-06 7:13

I´m working with a template using ADO inside a Windows Service to connect to an SQL Server but I´m getting an "access violation". The following is part of the code that:

#import "C:\Program Files\Common Files\System\ADO\msado15.dll" rename("EOF", "EndOfFile")
#import "C:\Program Files\Common Files\System\ado\MSJRO.DLL" no_namespace

typedef ADODB::_RecordsetPtr RecPtr;
typedef ADODB::_ConnectionPtr CnnPtr;

....
CnnPtr m_Cnn;

HRESULT hr;
hr = m_Cnn.CreateInstance( __uuidof( ADODB::Connection ) );
m_Cnn->Open(CnnStr, UserName, Pwd, NULL); <--- I´m getting the error here

Does any one have a clue on how to solve the problem?
Thanks,
Adrian

Re: Access violation in ADODB::Connection

lparsonson21-Feb-06 4:35

lparsonson

21-Feb-06 4:35

Try passing adConnectUnspecified instead of NULL in the Open function. And what are you using as your connection string?

Re: Access violation in ADODB::Connection

Dyrl21-Feb-06 8:48

Dyrl

21-Feb-06 8:48

Hi,
I´ve tried the adConnectUnspecified but I´m still getting the same error.
I´m using the following string to connect the DB:

static char CnnStr[200]="Provider=sqloledb;Data Source=SAUCE; \
Initial Catalog=loadDB; \
User Id=admin;Password=admin;";
in the:
dbConn->Open("admin","admin",CnnStr)

I´m using the sample in http://www.codeguru.com/cpp/data/mfc_database/ado/article.php/c6729/
to build my service. In fact that example worked ok as an executable, but then when I tried to run it in a Windows Service I began to receive this "access violation" messages. Then I create it dynamicaly (dbConn=new ADOConnect()) , ´cause I thought that these was the problem, but the problem persists.
Thanks,
Dyrl

Re: Access violation in ADODB::Connection

lparsonson21-Feb-06 22:39

lparsonson

21-Feb-06 22:39

Hmmm.

Well, firstly, if you have the username and password in your connection string, you don't need them in the Open function, you can leave them both as "" there.

Secondly, are you initialising the Com interface? You need to run

::CoInitialize(NULL);

before running any ADO code in C++ - I had this problem for a long time when I was first learning! If you don't use this line you will get a pretty serious error - i.e. it won't work!

AcitveX component, "off form", like the timer

david_reynolds19-Feb-06 14:37

david_reynolds

19-Feb-06 14:37

Hello,

I was wondering how to build an ActiveX control that integrates as a component "off the form" (say when using VB.net '03 or VB.NET '05). This is a component that has no user interface (except perhaps an icon) and needs never to be visible. I tried all of the various flags in the DECLARE_VIEWSTATUS macro to no avail. For example, the timer object in VB.NET is never on the form; it is shown as a component below the form.

I have experience with COM and ActiveX; I just do not know how to make my component behave like the 'timer' component.

Thanks in advance,

Dave.

how to load xml schema from resource?

dolph_loe19-Feb-06 10:32

dolph_loe

19-Feb-06 10:32

Hi I want to include an xml validation schema as a part of an executable. My problem is how to add the schema to the MSXML2::XMLSchemaCache40. I have a schema called 'setup.xsd', and m_schemaCache is a MSXML2::IXMLDOMSchemaCollection2 interface to XMLSchemaCache40.

The following code works ('setup' is the namespace for the schema).

<br />
hr = m_schemaCache->add(L"setup", L"Setup.xsd");<br />

Now I want to load the schema from a resource. Since IXMLDOMSchemaCollection2::add only accepts url's or MSXML2::DOMDocument's, I decided to parse the xml data using DOMDocument, and then pass the DOMDocument over to the XMLSchemaCache40.

In the following code, everything seems to be ok until I try to add the DOMDocument to the XMLSchemaCache40. The resource is loaded, The DOMDocument parses it, and no errors are found. The readyState of the DOMDocument is 4.

<br />
//Create resource name from resource id<br />
wchar_t  sResName[10];<br />
swprintf_s(sResName, 10, L"#%d", resourceId);<br />
<br />
//Locate the resource<br />
TCHAR sRestype[13] = _T("SCHEMA");<br />
HRSRC hres = FindResource(NULL, sResName, sRestype);<br />
if (hres == 0) { <br />
	return false;<br />
}<br />
<br />
//If resource is found a handle to the resource is returned<br />
//now just load the resource<br />
HGLOBAL    hbytes = LoadResource(NULL, hres);<br />
<br />
// Lock the resource<br />
LPVOID pdata = LockResource(hbytes);<br />
<br />
//Convert the resource text file to data we can use<br />
LPBYTE sData = (LPBYTE)pdata;<br />
BSTR sXml = _bstr_t((char*) sData);	<br />
<br />
//Crate instance of DOM parser<br />
MSXML2::IXMLDOMDocument* doc;<br />
hr = CoCreateInstance(__uuidof(MSXML2::DOMDocument), NULL, CLSCTX_ALL,<br />
		__uuidof(MSXML2::IXMLDOMDocument), (void**) &doc);<br />
if (FAILED(hr))<br />
	return false;<br />
<br />
//We don't want async read<br />
doc->put_async(VARIANT_FALSE);<br />
doc->put_validateOnParse(VARIANT_TRUE);<br />
<br />
//Parse the xml schema we just loaded from our resources<br />
VARIANT_BOOL succeeded;<br />
hr = doc->loadXML(sXml, &succeeded);<br />
if (succeeded != VARIANT_TRUE) {<br />
	//Load failed<br />
	return false;<br />
}	<br />
<br />
//HERE IT FAILS!!!!!!<br />
//Add the loaded schema to the schema collection<br />
hr = m_schemaCache->add(bstrNamespace, _variant_t(doc));<br />
if ( FAILED(hr) )<br />
	return false;<br />
<br />
return true;<br />

What am I doing wrong? Thanks in advance for any answers Smile | :)

øivind

ocx replace

mahmoodi18-Feb-06 20:29

mahmoodi

18-Feb-06 20:29

how do i protect an activex not to replace?

BindToStorage HRESULT fails while using IPropertyBag2

nripun18-Feb-06 3:48

nripun

18-Feb-06 3:48

<br />
ICreateDevEnun *pSysDevEnum<br />
IEnumMoniker *pEnumCat;<br />
IMoniker *pMoniker;<br />
IPropertyBag2 *pPropBag2;<br />
ULONG cFetched;<br />
hr = CoCreateInstance(CLSID_SystemDevEnum, NULL, CLSCTX_INPROC_SERVER,<br />
                      IID_ICreateDevEnum, (void**)(&pSysDevEnum));<br />
hr = pSysDevEnum->CreateClassEnumerator(CLSID_VideoInputDeviceCategory,<br />
                                        &pEnumCat, 0);<br />
while(pEnumCat->Next(1, &pMoniker, &cFetched) == S_OK){<br />
      hr = pMoniker->BindToStorage(0,0,IID_IPropertyBag2,(void**)pPropBag2);<br />
<br />

The above code produced FAILED(hr)== true at BindToStorage. But it succeeded if IPropertyBag was used instead

What could be the reason?

Re: BindToStorage HRESULT fails while using IPropertyBag2

mbue18-Feb-06 21:18

mbue

18-Feb-06 21:18

The moniker from a device is not a file-moniker. so you can't bind it to a storage. look at IMoniker in your SDK help.

Event Notification using Windows MAnagement Instrumentation

abhiramsss17-Feb-06 1:14

abhiramsss

17-Feb-06 1:14

hi all

iam working on WMI . iam trying to write an application for Event notification.

Iam usimg Win32_Process class, and ExecNotificationQuery for WQl query.

Iam trying to display a message when a new process is created.

my WQL query is

hres = pSvc->ExecNotificationQuery(
bstr_t("WQL"),
bstr_t("SELECT * FROM __InstanceCreationEvent WITHIN 5 WHERE TargetInstance ISA 'Win32_Process' And (TargetInstance.Name = 'notepad.exe' OR TargetInstance.Name = 'calc.exe' ) "),
WBEM_FLAG_FORWARD_ONLY | WBEM_FLAG_RETURN_IMMEDIATELY,
NULL,
&pEnumerator);

if iam not wrong ,After executing this query TargetInstance will be Instance of WIn32_process class.

and now iam trying extract data usoing this statement

hr = pclsObj->Get(L("TargetInstance.Name"), 0, &vtProp, 0, 0);

but iam not able to get value of Name property of Win32_Process class into vtProp where vtProp is of type VARIANT.

IWbemClassObject->Get( LPCWSTR wszName,LONG lFlags, VARIANT* pVal,CIMTYPE* pvtType, LONG* plFlavor) is used to retrieves Specified property value.

but here iam using it for getting value fron an istance i.e TargetInstance.Name. Is it the correct way to do if not please help me in extracting value of Name Property.

Please help me in solving this .

Thanks in advance

abhi

Re: Event Notification using Windows MAnagement Instrumentation

oshah20-Feb-06 3:11

oshah

20-Feb-06 3:11

abhiramsss wrote:
hr = pclsObj->Get(L("TargetInstance.Name"), 0, &vtProp, 0, 0);

I doubt you can get the TargetInstance.Name this way. I'd Get the TargetInstance, put that into a IWbemClassObject, then call Get again to retrieve the Name property of TargetInstance.

Re: Event Notification using Windows MAnagement Instrumentation

abhiramsss21-Mar-06 21:18

abhiramsss

21-Mar-06 21:18

I want to display a message when a process is closed can u please advice me regarding this.

Thanks in Advance

abhi

Re: Event Notification using Windows MAnagement Instrumentation

oshah22-Mar-06 1:03

oshah

22-Mar-06 1:03

Once you've got the ProcessID, open up a handle to it and wait on it. I *think* Unsure | :~

you can get the process handle directly by Win32_Process::Handle, but in case you can't OpenProcess/WaitForSingleObject will work.

Re: Event Notification using Windows MAnagement Instrumentation

abhiramsss2-Apr-06 23:37

abhiramsss

2-Apr-06 23:37

Hi

iam working on WMI(windows MAnagement Instrumentation). i have created a sample application using WIn32_process class . iam able to display messages when an Process is opened or closed.

now what i want to do is to create an object and then register a call back function . This class also take process names through another method . this class should call the above callbackfunction when one of the process(taken through the above method) is either started or exited.

can you please suggest me how to procedd with this task.

Thanks in advance

abhi

Re: Event Notification using Windows MAnagement Instrumentation

abhiramsss5-Apr-06 19:21

abhiramsss

5-Apr-06 19:21

HI

i want to create a wrapper class of win32_Process class and i want to define my own methods into that wrapper class and after that i want to display messages whenever a new process is started or class using that wrapper class .

Can you please suggest how to procedd with this

Thanks in Advance

abhi

Re: Event Notification using Windows MAnagement Instrumentation

abhiramsss22-May-06 19:17

abhiramsss

22-May-06 19:17

Can u please suggest me how to write call back function for Event notification whenever a new process is executed using WMI

Thanks
Abhi

abhi

Re: Event Notification using Windows MAnagement Instrumentation

oshah23-May-06 6:42

oshah

23-May-06 6:42

Let's start off with a little modification of your original code. Use this WMI query instead, "Select * From Win32_ProcessStartTrace" to get notified of process creation.

Now to receive notification whenever a new Win32_ProcessStartTrace is fired, you need to invoke that WMI query with ExecNotificationQueryAsync. This operates almost exactly like ExecNotificationQuery, except it takes one extra parameter: a pointer to your implementation of IWbemObjectSink.

If you don't have an implementation of IWbemObjectSink, just use the stock implementation from MSDN[^] or Codeproject[^].

But why do you need to be notified when a new process is being created? What are you going to do to the process?

Re: Event Notification using Windows MAnagement Instrumentation

abhiramsss28-May-06 23:36

abhiramsss

28-May-06 23:36

thanks for your suggestion i will try to implement it.

actually iam working on a network.

so now i want to display messages remotely . Saty there aretwo machines A and B so whenever a exe is executed on machine B it should display message on machine A,

so please suggest me how to work remotely using WMI.

Thanks in Advance

abhi

abhi

Re: Event Notification using Windows MAnagement Instrumentation

oshah29-May-06 6:54

oshah

29-May-06 6:54

I thought Windows already provided this functionality via the Event logs.

System Policy editor (gpedit.msc) -> Computer Configuration -> Windows Settings -> Security Settings -> Local Policies -> Audit Policy -> Audit process tracking (audit success). D'Oh! | :doh:

Unfortunately, this option also audits a heap of other events, in addition to process startup/shutdown.

Re: Event Notification using Windows MAnagement Instrumentation

abhiramsss30-May-06 20:48

abhiramsss

30-May-06 20:48

Hi,

Can u please suggest me how to get WMI data from a remote computer

Can u please suggest me the changes i have to do in Connectserver Function and the required DCOM settings required to access data remotely.

Thank you
Abhi

abhi

Re: Event Notification using Windows MAnagement Instrumentation

abhiramsss12-Jun-06 21:03

abhiramsss

12-Jun-06 21:03

hi
iam trying to access remote data using the following arguments in ConnectServer

hres = pLoc->ConnectServer(
_bstr_t(L"\\\\test\\root\\cimv2"),
_bstr_t(L"kumar"), // User name
_bstr_t(L"Keta001"), // User password
_bstr_t(L"MS_409"), // Locale
NULL, // Security flags
_bstr_t(L"CRAFT"), // Authority
0, // Context object
&pSvc // IWbemServices proxy
);
where test is the name of testPC
kumar is the username of remote PC
Keta001 is the password
CRAFT is the domain name

but when iam running my application iam getting error
cannot be connected error code 80041008

can u please suggest how to solve this.

Thanks In Advance

abhi

Re: Event Notification using Windows MAnagement Instrumentation

abhiramsss26-Jun-06 18:18

abhiramsss

26-Jun-06 18:18

hi when iam tryig to acquire UPS data using WIN32_UninterruptiblePowerSupply class of WMI ,iam not able to get the output,and i have searched on net for the solution , what i found is

Most UPS's now days disable native OS support when they install, because
they want to use their agent program instead. A good example is APC. So if
your using an APC by default it turns off UPS support (Maybe MS needs to
beef up the UPS support so APC doesnt feel they need to do this for
functionality). So in this case WMI wont be any help. But IF your UPS uses
the built in UPS support Windows provides then you should be ok

can u please elaborate on this and tell me how to get UPS data.

Thanks in Advance

abhi

Windows MAnagement Instrumentation

abhiramsss7-Nov-06 14:32

abhiramsss

7-Nov-06 14:32

Hi iam working on winows 2003 clustering and i have to use WMI.

can u please help me with waht all we can do with WMI wrt to clustering

and can i have sample scripts

Thanks in advance

abhi

Service Objects

waxie16-Feb-06 22:05

waxie

16-Feb-06 22:05

Hi all,

I would like to ask if anybody is knowledgeable in service objects? Can anyone recommend a site or provide me with documentation for me to understand more about service and control objects?

Big Grin | :-D

Thanks a lot,

Rose | [Rose]

waxie

How to realize my own shell format?

Jerry New16-Feb-06 15:20

Jerry New

16-Feb-06 15:20

Hi,

Can I write a shell extension which can process my own shell format?
For example: I have an application which has own data format, and when
drag from this applicaion and drop on explorer, the extension can process this data format.

It's like when you drag some texts and drop on explorer, which generate some special file.

Of course, I want generate my own files.
Anyone can help me?

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.