Klemens
Sun Jun 03 05:06:16 CDT 2007
Time teaches:
You can write a OLE DB Simple Provider in VB6 by implementing the
OLEDBSimpleProvider interface. It is easy. Google for "AxData". This
sample was once delivered with VS6. Shouldn't be too difficult to do
the same with VB.NET. However, the bad news is that this provider is
_too_ simple for consumers like Excel 2007. You can use it perfectly
in VS projects by putting a data control in between. But Excel can't
do this and therefore you don't have a chance to pass the DataMember
in.
- Klemens
On 21 Mai, 05:31, "Robert Simpson" <rmsimp...@noemail.noemail> wrote:
> The only way for you to write a ODBC or OLEDB wrapper is in C++. You can=
of
> course compile with the /CLR option and include an ADO.NETprovider, but a=
ll
> 3 technologies are vastly different and completely independent of one
> another.
>
> There are ADO.NET wrappers for ODBC and OLEDB providers, but not the other
> way around. It would actually be an interesting project to write a gener=
ic
> ODBC or OLEDB wrapper for an ADO.NETdataprovider.
>
> Robert Simpson
> Programmer at Large
http://sqlite.phxsoftware.com
>
> "Klemens" <kle...@gmail.com> wrote in message
>
> news:1179695091.699295.232130@y2g2000prf.googlegroups.com...
> I hoped it would become a lot easier with .NET. At least implementing
> pure .NETdataproviders is not a big deal. However, I don't know
> which shell to put round this to make it accessible to OLEDB or ODBC
> consumers liek Excel. Shouldn't there be a generic way? As this is not
> my core business I would need to dry my plans.
> Thanks anyway.
> -Klemens
>
> On 17 Mai, 12:26, "William \(Bill\) Vaughn"
>
>
>
> <billvaRemoveT...@betav.com> wrote:
> > ODBCDataProviders are not that hard to write for a skilled developer but
> > I
> > expect the documentation is too old to be committed to the web. Kyle
> > Geiger's book might give you that
> > insight.
http://www.amazon.com/Inside-Odbc-Microsoft-programming-Geiger/=
dp/155....
> > OLE DBDataProviders can be quite difficult to write. The spec is about
> > 10"
> > thick. I would not recommend anyone off campus to attempt this without a
> > lot
> > of help--which as you discovered can be hard to find.
>
> > --
> > ____________________________________
> > William (Bill) Vaughn
> > Author, Mentor, Consultant
> > Microsoft MVP
> > INETA Speakerwww.betav.com/blog/billvawww.betav.com
> > Please reply only to the newsgroup so that others can benefit.
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > __________________________________
> > Visitwww.hitchhikerguides.nettoget more information on my latest book:
> > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> > -----------------------------------------------------------------------=
----=AD=AD--------------------------------------------
>
> > "Klemens" <kle...@gmail.com> wrote in message
>
> >news:1179360183.632920.117060@o5g2000hsb.googlegroups.com...
>
> > >I would like to create my own dataproviderin .NET which is able to
> > > deliverdatato all apps supporting oledb or odbc. Information about
> > > this is very rare in the Web. Are there any code samples around or
> > > books from which I could learn how to do this? Important, again, is
> > > the part which makes theprovidervisible to Excel etc.
> > > -Klemens- Zitierten Text ausblenden -
>
> > - Zitierten Text anzeigen -- Zitierten Text ausblenden -
>
> - Zitierten Text anzeigen -