ole db

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of glenn
Sent: Wednesday, 24 March 2004 15:10
To: PgSQL General ML
Subject: [GENERAL] ole db

Hi -
I notice on the gborg site ( I really gotta look around there more
often) there's an OLE DB project, which will allow users of visual
studio to connect to postgres without odbc. Does anyone know if that
ability can be utilised in msaccess?
tia
Glenn

It's a dead project ... I couldn't find any useable output (that's more an indictment of my coding skills than anything else). I signed up and contacted the other two developers listed, but never got a response. If you're keen on the OLE DB / ADO play ground, you'll need to use the OLEDB-ODBC bridge with the ODBC driver.

Ciao
Fuzzy
:-)

It's a dead project ... I couldn't find any useable output (that's more an indictment of my coding skills than anything else). I signed up and contacted the other two developers listed, but never got a response. If you're keen on the OLE DB / ADO play ground, you'll need to use the OLEDB-ODBC bridge with the ODBC driver.

If you are using a version of MS Access that can utilize .net then you
should look on sourceforge. I know of at least two projects over there
that are ADO.Net drivers for PostgreSQL...

J

Ciao
Fuzzy
:-)

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Grant Allen wrote:

It's a dead project ...

Used to be dead. Not any more.

I couldn't find any useable output (that's more an indictment of my coding skills than anything else).

Then you haven't tried over the past month or two. The version released
there already has some results support. The CVS is much better already.
I'm attempting to get some sort of basic functionality ordered out, and
then I'll do another release.

I signed up and contacted the other two developers listed, but never got a response. If you're keen on the OLE DB / ADO play ground, you'll need to use the OLEDB-ODBC bridge with the ODBC driver.

Yes, so did I. I then contacted the hackers list. I then opened a new
project, at which point the gborg admin just handed me control over the
old project. Along the way, I found out the email for the old project
maintainer, as well as another group which is not tightly related to
postgres who began work on similar project. They are all subscribed to
the oledb-dev mailing list (though I have not heard from any of them of
late).

At the moment, the ole-db driver (the CVS version) is quite capable of
doing basic queries (yes, including getting the results to the app :-).
I'm slowly putting more stuff in, but would love to get any help with
this you (or glenn) can offer. For example - current version still does
not properly report NULL columns, resulting in junk results in columns
with no data. Still loads of work ahead, but defenitely better than it
used to be.

Instructions on how to pull the CVS version and compile it can be found
at http://gborg.postgresql.org/project/oledb/cvs/co.php/oledb/INSTALL?r=1.3

Ciao
Fuzzy
:-)

Shachar

--
Shachar Shemesh
Lingnu Open Systems Consulting
http://www.lingnu.com/

-----Original Message-----
From: Shachar Shemesh [mailto:psql@shemesh.biz]
Sent: Thursday, 25 March 2004 05:39
To: Grant Allen
Cc: pgsql-general@postgresql.org; PostgreSQL OLE DB development;
gdavy@tpg.com.au
Subject: Re: [GENERAL] ole db

Grant Allen wrote:

It's a dead project ...

Used to be dead. Not any more.

I couldn't find any useable output (that's more an

indictment of my coding skills than anything else).

Then you haven't tried over the past month or two. The
version released
there already has some results support. The CVS is much
better already.
I'm attempting to get some sort of basic functionality
ordered out, and
then I'll do another release.

That's great news, Shachar - thanks for bringing me up to date.

I'll take a look at the CVS, and see where I can help. I'll jump on to the dev list as well.

Thanks again

Fuzzy
:-)