Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-15 Thread Marc Santhoff
Am So, den 13.03.2005 schrieb Lawrence Harriott um 20:06: > Hi Marc, Hi Lawrence, [...] > > > > > > - go step by step: test the db for access rights, do that over the local > > > > net, test access with isql, then use applications > > > > > > Done all that and a few more. The isql and other tes

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-13 Thread Josh Berkus
Lawrence, > > > By native I suspect you mean MyODBC. I get the exact same results using > > > it as using unixODBC. Even the work around seems to work the same for > > > both. Nope, I was referring to the SDBC driver for OOo. Should work much better than ODBC on Linux. What I find a shame is

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-13 Thread Lawrence Harriott
Hi Alex, On Sun, 2005-03-13 at 08:44 +0100, Alex Thurgood wrote: > Le dimanche 13 mars 2005 à 01:53 -0500, Lawrence Harriott a écrit : > > Hi Lawrence, > > > > > Additionally, I have used the MySQL downloaded from MySQL and the one > > > > supplied with MDK10.1. Same results. I think at this po

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-13 Thread Lawrence Harriott
Hi Marc, On Sun, 2005-03-13 at 18:06 +0100, Marc Santhoff wrote: > Hi Lawrence, > > Am So, den 13.03.2005 schrieb Lawrence Harriott um 07:53: > > On Sun, 2005-03-13 at 01:31 +0100, Marc Santhoff wrote: > > > Am Sa, den 12.03.2005 schrieb Lawrence Harriott um 22:33: > > > > Hi Josh, > > > > > > I

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-13 Thread Marc Santhoff
Hi Lawrence, Am So, den 13.03.2005 schrieb Lawrence Harriott um 07:53: > On Sun, 2005-03-13 at 01:31 +0100, Marc Santhoff wrote: > > Am Sa, den 12.03.2005 schrieb Lawrence Harriott um 22:33: > > > Hi Josh, > > > > I'm not, but I'll try to help... > Sorry about the name Marc. Honest mistake. No n

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-12 Thread Alex Thurgood
Le dimanche 13 mars 2005 à 01:53 -0500, Lawrence Harriott a écrit : Hi Lawrence, > > > Additionally, I have used the MySQL downloaded from MySQL and the one > > > supplied with MDK10.1. Same results. I think at this point it is fair to > > > say that the problems are not user errors. The ODBC in

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-12 Thread Lawrence Harriott
On Sun, 2005-03-13 at 01:31 +0100, Marc Santhoff wrote: > Am Sa, den 12.03.2005 schrieb Lawrence Harriott um 22:33: > > Hi Josh, > > I'm not, but I'll try to help... Sorry about the name Marc. Honest mistake. > > > By native I suspect you mean MyODBC. I get the exact same results using > > it as

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-12 Thread Marc Santhoff
Am Sa, den 12.03.2005 schrieb Lawrence Harriott um 22:33: > Hi Josh, I'm not, but I'll try to help... > By native I suspect you mean MyODBC. I get the exact same results using > it as using unixODBC. Even the work around seems to work the same for > both. There is a driver for PostgrSQL, look th

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-12 Thread Lawrence Harriott
Hi Josh, By native I suspect you mean MyODBC. I get the exact same results using it as using unixODBC. Even the work around seems to work the same for both. Additionally, I have used the MySQL downloaded from MySQL and the one supplied with MDK10.1. Same results. I think at this point it is fair t

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-12 Thread Marc Santhoff
Am Sa, den 12.03.2005 schrieb Josh Berkus um 20:44: > People: > > What about using the "native" driver instead of ODBC? Personally, I've > always found unixODBC and iODBC to be a bit flakey on Linux. Hey, you're right. The SDBC driver is still under development but my last impression was it sh

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-12 Thread Josh Berkus
People: What about using the "native" driver instead of ODBC? Personally, I've always found unixODBC and iODBC to be a bit flakey on Linux. -- Josh Berkus Aglio Database Solutions San Francisco - To unsubscribe, e-mail: [EMA

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-11 Thread Marc Santhoff
Am Fr, den 11.03.2005 schrieb Marc Santhoff um 20:13: [...] > Would you mind contributing a little FAQ yourself? s/FAQ/HowTo/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-11 Thread Lawrence Harriott
Marc I would be happy to contribute in any way I can to help. A FAQ would not be a problem. I am a bit loaded with work a the moment though, so will see what I can do in the coming week. Lawrence On Fri, 2005-03-11 at 20:13 +0100, Marc Santhoff wrote: > Am Fr, den 11.03.2005 schrieb Lawrence Har

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-11 Thread Marc Santhoff
Am Fr, den 11.03.2005 schrieb Lawrence Harriott um 15:50: > I responded earlier to this post then noticed this entry in my mailbox. > For some reason, although I subscribed, the digest does not reach my > mailbox, so I am not seeing the full discussion. > > As I pointed out earlier, the problem ap

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-11 Thread Lawrence Harriott
I responded earlier to this post then noticed this entry in my mailbox. For some reason, although I subscribed, the digest does not reach my mailbox, so I am not seeing the full discussion. As I pointed out earlier, the problem appears to be in the OOo integration of ODBC, not necessarily ODBC its

Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-11 Thread Marc Santhoff
Am Fr, den 11.03.2005 schrieb Ennio-Sr um 03:18: > Hi all! > [using GNU/Linux Debian/Sarge k 2.4.27 and either OOo-1.1.4 or 1.9.79] > > I'm unable to access my postgresql databases via the ODBC driver: > has any of you achieved this goal and can he suggest some hints? > I followed the indications

[dba-dev] [OT]OOo, ODBC and PostgreSQL database

2005-03-10 Thread Ennio-Sr
Hi all! [using GNU/Linux Debian/Sarge k 2.4.27 and either OOo-1.1.4 or 1.9.79] I'm unable to access my postgresql databases via the ODBC driver: has any of you achieved this goal and can he suggest some hints? I followed the indications in /usr/share/doc/odbcinst1 and many other docs found googlin