problem obtaining IRowsetChange with Ole Db provider for Oracle

From: <marijke.kerwijn_at_skynet.be>
Date: Wed, 03 Feb 1999 15:47:51 GMT
Message-ID: <799r33$hkj$1@nnrp1.dejanews.com>

That Ole Db Provider for Oracle does not support IRowsetChange is known, but the MSDN Library says that if you CoCreateInstance with CLSID_MSDAINITIALIZE instead of CLSID_MSDASQL to obtain IDataInitialize , you should be possible to use IRowsetChange (provided then by MS Service Components (which should give you additional interfaces not supported by the native ole db provider) instead of only the Ole Db provider)
I do this and it works but i still can't obtain an IRowsetChange interface (E_NOINTERFACE) e.g. :
// defining a connection string to obtain the datasource
static LPCWSTR s_pwszDataSource =

				L"Provider=MSDAORA;"   // Oracle provider
				L"Data Source=ORACLESERV1.WORLD;"
				L"User ID=po8;"
				L"Password=po8;"  // is this connection string
						  // missing something ?

main()
{
HRESULT hr;
IUnknown *pUnkDataSource = NULL;
IDataInitialize* pIDataInitialize = NULL; hr = ::CoCreateInstance(CLSID_MSDAINITIALIZE, NULL, CLSCTX_INPROC_SERVER, IID_IDataInitialize, (LPVOID*)&pIDataInitialize);

	if(pIDataInitialize)
	{	hr = pIDataInitialize->GetDataSource(NULL,
	                                             CLSCTX_INPROC_SERVER,
	                                             s_pwszDataSource,
	                                             IID_IUnknown,
	                                             &pUnkDataSource);
	        pIDataInitialize->Release();
	}

}
// etc.
// when you QueryInterface for IRowsetChange on the obtained IRowset interface
// you get E_NOINTERFACE

Can Anybody help me,
Thanx !

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 03 1999 - 09:47:51 CST