Thread: 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
> -----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 anythingelse). I signed up and contacted the other two developers listed, but never got a response. If you're keen on theOLE 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 / ADOplay 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 :-)