[GENERAL] OLE DB
Hi Chaps, I was just wondering about the state of ole db connectivity for postgresql. From what I can see my options are; http://pgfoundry.org/projects/oledb/ Which doesn't seem to have been updated for 3 years - anyone using it? Or http://www.pgoledb.com/ Any others? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ole db
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 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
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. 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/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] ole db
-Original Message- From: Shachar Shemesh [mailto:[EMAIL PROTECTED] Sent: Thursday, 25 March 2004 05:39 To: Grant Allen Cc: [EMAIL PROTECTED]; PostgreSQL OLE DB development; [EMAIL PROTECTED] 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 :-) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster