Ahh, that would be us then :-) Yes, there is a (very) active .NET
provider project underway - it can be found at
http://gborg.postgresql.org/project/npgsql. Note though, that this is a
native .NET provider being written in C#, it is not OLE-DB (which would
certainly be a useful addition to the list of interfaces imho).

Regards, Dave.



> -----Original Message-----
> From: Christopher Kings-Lynne [mailto:chriskl@familyhealth.com.au] 
> Sent: 17 June 2002 09:34
> To: Marek Mosiewicz; PostgreSQL-development; PostgreSQL odbc list
> Subject: Re: [HACKERS] Native OLE DB. What do you think about it
> 
> 
> Are you aware that another team on the list is working on a 
> .Net provider? Maybe you could work with them?
> 
> .Net Provider people: speak up!
> 
> Chris
> 
> > -----Original Message-----
> > From: pgsql-hackers-owner@postgresql.org
> > [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Marek 
> > Mosiewicz
> > Sent: Monday, 17 June 2002 4:34 PM
> > To: PostgreSQL-development; PostgreSQL odbc list
> > Subject: [HACKERS] Native OLE DB. What do you think about it
> >
> >
> > Hello everbody.
> >
> > I have started work on native OLE DB Provider for 
> PostgreSQL. i think 
> > it is really important to have native OLE DB proviader even 
> if there 
> > is OLE DB to
> > ODBC Provider. Microsoft started to withdraw support for 
> ODBC and seems to
> > force to switch to OLE DB(eg VS .Net have limited support 
> for ODBC which
> > must be spearetly downloaded), so we could expect more such 
> moves. So I
> > started work on native PostgreSQL OLE DB provider. It slowly begin
> > to work. (it registers to system, shows property pages, connects to
> > database, and do first quries). Now I'm working on creating 
> resultset.
> >
> > I would like somebody to help answer some questions:
> >
> > 1.is it safe to use binary cursors (basic types format e.g 
> date would 
> > not change in future) 2.how could I control result type 
> (binary/ASCII) 
> > for ordinary SELECTS ? 3.could ODBC driver mix auto-commit and 
> > FETCH/DECLARE mode ? how it can handle such situation:
> >     start select (fetch some data) /as I understand it should start
> > transaction silently/
> >     update (it should commit as we are in auto-commit)
> >     fetch more data.
> >     next update (commit again)
> > 4. maybe it would have sense to make some common library with
> > ODBC to handle
> > prepared statements and some kind of conversions (althougth 
> maybe not
> > becouse we convert to different types (OLE DB uses OLE 
> Automation types))
> > 5. Is there any way to truncate PQresult in libpq ? I implement
> > fast forward
> > cursors so i have no need to store whole result (I can read 
> piece of data
> > and forget it when client read it from me). I think there 
> would be no
> > problem if I add some PQtruncate(PQresult *) to pqlib, but 
> maybe there is
> > any different way ?
> >
> > I use ATL templates for OLE DB which is MS library and it can't be 
> > compiled withot Visual Studio. (you have right to distribute ATL if 
> > you bougth VS). So It would be not "pure" solution, but 
> starting from 
> > scratch is to difficult, as I don't know COM prefectly. 
> Maybe somebody 
> > will rewrite it later.
> >
> >
> >
> > ---------------------------(end of 
> > broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an 
> appropriate subscribe-nomail command to 
> majordomo@postgresql.org so that your message can get through 
> to the mailing list cleanly
> 

Mon, 17 Jun 2002 12:48:56 +0100
"Dave Page" <dpage@vale-housing.co.uk>
Re: [HACKERS] Native OLE DB. What do you think about it
> Ahh, that would be us then :-) Yes, there is a (very) active .NET
> provider project underway - it can be found at
> http://gborg.postgresql.org/project/npgsql. Note though, that this is a
> native .NET provider being written in C#, it is not OLE-DB (which would
> certainly be a useful addition to the list of interfaces imho).


If that's the case, can I please make a suggestion: please liaise with
the Mono project's ADO.NET people (http://www.go-mono.com) as they are
doing exactly the same thing, and there's no need for duplication of
effort.

Martin


17 Jun 2002 13:05:00 +0100
Martin Coxall <coxall@cream.org>
Re: [HACKERS] Native OLE DB. What do you think about it