How to use ADO.NET Managed Provider in Excel?

Question

I have an ADO.NET managed data provider that is registered in machine.config in DbProviderFactory. It is available for use, say, for Analysis Services, so I know that it is correctly registered.

However, I need to be able to query the managed provider from Excel, but the managed provider does not appear as a selection from the Data Link | All suppliers of Ole Db.

How can I get a managed ADO.NET data provider, or is there another method that I need to use there?

Thanks in advance, Eli.

Answer 1

, ADO.NET Excel.

OLE DB ( ATL ++ ), - ...

Answer 2

, ADO.NET - http://support.microsoft.com/kb/316934#12

Answer 3

.

CLR, , , SQL- .

SQLServer OLE DB ODBC.

, .