BDC with custom ADO.NET data provider

Is this the right place to ask MOSS 2007 beta questions?

I bugged several people at Tech Ed and could not find an answer to this one:
I was told there that I can use any ADO.NET 2.0 compliant data provider in
the SharePoint 2007 Business Data Catalog. I have examined the BDC samples
and documentation in the MOSS 2007 SDK and still can not see how I would
plug in my own custom ADO.NET data provider in there. Here is a snippet
from the sample XML file

<LobSystemInstance Name="AdventureWorksSampleInstance">
<Properties>
<Property Name="DatabaseAccessProvider"
Type="System.String">SqlServer</Property>


The string "SqlServer" does not match any of the entries in machine.config,
where ADO.NET 2.0 drivers are registered, so I conclude that there must be
something in between. "SqlServer" might be referring to the
Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db enumeration
(which can be Odbc, OleDb, Oracle, or SqlServer); if so the claim of
supporting any .NET 2.0 compliant data driver may be FALSE.

Any insight into this issue would be very much appreciated!

Thanks!

Engelbert
Sun Jun 18 09:11:50 CDT 2006

> Is this the right place to ask MOSS 2007 beta questions?

Well certainly not *both* the .portalserver and the
.portalserver.development are the right place - i.e. there is no need to
post the same message twice.

There is no "right" place. You decide which single newsgroup to post to
depending on your question.

If posting here (and .development) you should include "MOSS2007" in the
subject line as the assumption here if that is not stated is that you are
posting a SPS 2003 question.

There are also four different new newsgroups - as these cover all SharePoint
products past, present and future it is also necessary there to write
MOSS2007 in the Subject. There no assumptions are made.

Those four newsgroups are
microsoft.public.sharepoint.design_and_customization
microsoft.public.sharepoint.development_and_programming
microsoft.public.sharepoint.setup_and_administration
and
microsoft.public.sharepoint.general (for questions that don't fit any of the
three above)

Again you should only post to one of the above newsgroups (and also not to
an old newsgroup as well as to an old newsgroup!)

Engelbert

"Stephen Walch" <swalch@online.nospam> wrote in message
news:uL03o3ikGHA.1320@TK2MSFTNGP04.phx.gbl...
> Is this the right place to ask MOSS 2007 beta questions?
>
> I bugged several people at Tech Ed and could not find an answer to this
> one: I was told there that I can use any ADO.NET 2.0 compliant data
> provider in the SharePoint 2007 Business Data Catalog. I have examined
> the BDC samples and documentation in the MOSS 2007 SDK and still can not
> see how I would plug in my own custom ADO.NET data provider in there.
> Here is a snippet from the sample XML file
>
> <LobSystemInstance Name="AdventureWorksSampleInstance">
> <Properties>
> <Property Name="DatabaseAccessProvider"
> Type="System.String">SqlServer</Property>
> 
>
> The string "SqlServer" does not match any of the entries in
> machine.config, where ADO.NET 2.0 drivers are registered, so I conclude
> that there must be something in between. "SqlServer" might be referring
> to the Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db
> enumeration (which can be Odbc, OleDb, Oracle, or SqlServer); if so the
> claim of supporting any .NET 2.0 compliant data driver may be FALSE.
>
> Any insight into this issue would be very much appreciated!
>
> Thanks!
>

BDC with custom ADO.NET data provider

Re: BDC with custom ADO.NET data provider by Engelbert