Re: Way to interface with Dataset through ODBC or OLE?
- From: googlegroups.dsfm@xxxxxxxxxxxx
- Date: Thu, 08 Nov 2007 03:18:06 -0800
On Nov 6, 1:25 pm, Andrew Faust <andrew [at] andrewfaust.com> wrote:
Writing an ODBC driver is not trivial. You basically have to create a
standard Win32 DLL (not-managed) that exposes an interface conforming to the
ODBC standard. Your DLL can call in to managed code for the bulk of the
processing, but you'd still have to deal with formatting responses correctly.
I looked in to it once for work and was able to build a very basic proof of
concept driver to do a simple read of all records on a table.
If I can track down the code to my POC I'll post it on my website and
provide a link. I had changed source control since then, though, and didn't
bring it across. I'll need to dust off some backups.
The resources I used were the Open Source ODBC drivers for PostgreSQL & SQL
Lite as well as the ODBC API documentation in the MSDN library.
Depending on how databases are going to be accessed you may not need to do
this. You could build a set of classes that inherit from DbConnection,
DbCommand, DbDataReader, etc. that provides access. This would allow .Net
coders to access your database via standard .Net development. The downside is
it would only work for .Net development. Other tools that only talk to plain
ODBC wouldn't work.
--
Andrew Fausthttp://www.andrewfaust.com
Andrew,
Unfortunately, I wanted to avoid a .NET dependency - if I was going to
go to all the trouble to create classes inheriting from
System.Data.Db*, I'd just as soon spit out the resultant Dataset and
have the app deal with it clientside.
If you can find the POC, I'd be grateful. I'd at least like to give it
a shot if there's at least a basic framework to go by - and the real
benefit is that it would only need to accept SELECT statements, as
this is a one-way connection.
Thanks!
.
- References:
- Way to interface with Dataset through ODBC or OLE?
- From: googlegroups . dsfm
- Way to interface with Dataset through ODBC or OLE?
- Prev by Date: How to change directories using FtpWebRequest?
- Next by Date: Re: How: multiple program instances sharing same data
- Previous by thread: Re: Way to interface with Dataset through ODBC or OLE?
- Next by thread: EventHandler & Return Types
- Index(es):
Relevant Pages
|
