Registering OLE DB provider.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello
I've written a simple OLE DB provider from scratch (without ATL) and I have
problems with registering my provider with Microsoft Data Link.

These are steps I performed in order to register my DLL.

regsvr32 ComDll.dll

which makes following keys appear in the registry:

[HKEY_CLASSES_ROOT\ComDll.DummyDataSource]
@="Zbyszkowy Testowy OLE DB"

[HKEY_CLASSES_ROOT\ComDll.DummyDataSource\CLSID]
@="{af30aaaa-aaaa-abcd-ceE0-0F4A44FC38C4}"

[HKEY_CLASSES_ROOT\ComDll.DummyDataSource\CurVer]
@="ComDll.DummyDataSource.1"


[HKEY_CLASSES_ROOT\ComDll.DummyDataSource.1]
@="Zbyszkowy Testowy OLE DB"

[HKEY_CLASSES_ROOT\ComDll.DummyDataSource.1\CLSID]
@="{af30aaaa-aaaa-abcd-ceE0-0F4A44FC38C4}"

[HKEY_CLASSES_ROOT\CLSID\{af30aaaa-aaaa-abcd-ceE0-0F4A44FC38C4}]
@="ComDll.DummyDataSource"

[HKEY_CLASSES_ROOT\CLSID\{af30aaaa-aaaa-abcd-ceE0-
0F4A44FC38C4}\InProcServer32]
@="c:\\zbyszek\\projekty\\ComDll\\Debug\\ComDll.dll"
"ThreadingModel"="Apartment"

[HKEY_CLASSES_ROOT\CLSID\{af30aaaa-aaaa-abcd-ceE0-0F4A44FC38C4}\OLE DB
Provider]
@="Zbyszkowy Testowy OLE DB"
"OLEDB_SERVICES"=dword:ffffffff

[HKEY_CLASSES_ROOT\CLSID\{af30aaaa-aaaa-abcd-ceE0-0F4A44FC38C4}\ProgID]
@="ComDll.DummyDataSource.1"

[HKEY_CLASSES_ROOT\CLSID\{af30aaaa-aaaa-abcd-ceE0-
0F4A44FC38C4}\VersionIndependentProgID]
@="ComDll.DummyDataSource"

The end.

Unfortunatelly Microsoft Data Link still says that provider was not properly
installed.

I tried to attach debugger:
1. ClassFactory returns new DataSource object.
2. Object is queried for IDBProperies interface, which is returned (no error
here).
3. This is the last step, after returning this interface MDL shows "Provider
is no longer available. Check whether it was installed properly" (or smth.
like that - I have non English Windows, so I cannot present the actual
message).

According to msdn that is all, that I shoul put into register, but i appears
it is not enough.

ps. I double checked paths and key value.
.

Relevant Pages

  • Linked server to as400 - for the love of god please help.
    ... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ... OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ...
    (microsoft.public.sqlserver.server)
  • Problem with Linked Server from SQL to DB2
    ... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
    (microsoft.public.data.oledb)
  • RE: Samplclnt example in MDAC 2.8: My Story
    ... | OLE DB provider/consumer sample that is included in the MDAC 2.8 SDK. ... | what the consumer client uses to read the rudimentary .csv data file. ... | compiler errors. ... | sample OLE DB provider. ...
    (microsoft.public.data.oledb)
  • Re: Event Log errors
    ... > register them in event log. ... > Event Type: Error ... > Event Source: Windows Product Activation ... > A provider, Rsop Planning Mode Provider, has been registered in the WMI ...
    (microsoft.public.windowsxp.embedded)
  • RE: Database Lookup Functoid Connection String
    ... A OLE DB provider is a COM component which implement a number of COM ... And connection string is a way to initialize a OLE DB provider. ... accessed by the BizTalk server account, ...
    (microsoft.public.biztalk.general)