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 itself. It works fine on MS Windows (where ODBC originated). It appears that OOo does not check for permissions (and other things) at the same place that the DBMS does. Therefore, you are most likely going to find that isql (and any other external test) works fine but you have problems inside OOo. I posted my experiences and findings in the OOoforum under Mandrake10.1, OOo1.1.14, MySQL ... Have a look at it and see whether anything there might help in the mean time. Lawrence On Fri, 2005-03-11 at 13:46 +0100, Marc Santhoff wrote: > 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 in /usr/share/doc/odbcinst1 and many other > > docs found googling around but to no avail: in 1.1.4 it seems to have > > authentication problems; no particularly helpful error/warning in > > 1.9.79. Examining the postgres.log I can see the list of my databases, > > however no local port is shown ;( > > TIA. Regards, > > Ennio. > > Try "isql" from the ODBC-package and see if it can connect. If not, > check your odbc configuration. > > If that works and your psql server is not local but on the net, check if > the psql configuration on the server machine has network connections set > to "on" (AFAIR psql has a switch, look at it's docs). > > If odbc with psql works, try with OOo again. Maybe the db user rights > need some tweaking to get full access. > > HTH, > Marc > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
