postgres

From: pu (leejen666_at_hotmail.com)
Date: 03/29/04 

Date: Tue, 30 Mar 2004 01:10:36 +1000

Hi all,

On a laptop with psqlODBC installed, I can open an access database, and link
a table from postgresql 6.5 database on Linux 6.3. Using same laptop, I get
the following error message when trying to link a table from a postgresql
7.3 database on Linux 9.0. This database is new and trying it out to see if
I can upgrade everything to linux 9.0.

The errors I got when trying to link a table were:
ODBC Failed
Could not connect to server
Could not connect to remote socket ((#101)
- solved by adding tcpip_socket = true to postgresql.conf

ODBC Failed
FATAL: No Pg_Hba entry for host 192.168.0.3 , user postgres, database
MyDatabase, (#210)
- solved by adding:
host MyDatabase all 192.168.0.3 255.255.255.0
trust
to pg_hba.conf

But the one that really beats me is this one:
ODBC call failed
blank (#110)

I have googled this with no luck. I verified the postgresql server is
running.
[root@server root]# /etc/rc.d/init.d/postgresql restart
Stopping postgresql service: OK ]
Starting postgresql service: OK ]
[root@server root]# ps -ax | grep postgres
 4797 pts/2 S 0:00 su - postgres
 5196 pts/1 S 0:00 su - postgres
 5481 pts/3 S 0:00 postgres: stats buffer process
 5483 pts/3 S 0:00 postgres: stats collector process
 5491 pts/3 S 0:00 grep postgres

Anybody know what the error "Blank (#110)" means and how to solve this
problem?

Regards
Leigh

CC to leejen666@hotmail.com

Relevant Pages

  • Re: Windows Ada database support.
    ... >>for example) promote the use of Object IDs (basically Row IDs). ... >>Still others don't support the concept at all (MySQL). ... >>within certain database design restrictions). ... PostgreSQL uses an API that opens/creates etc. and returns ...
    (comp.lang.ada)
  • Running queries on large data structure
    ... the money) that parses multiple large text files containing nested data ... data from the PostgreSQL database by different criteria. ... Networks ...
    (comp.lang.python)
  • Re: PHP + PostgreSQL
    ... >database from a program running on the same machine, ... ...again) hold the main rule of this techtables web apps. ... 2-3 - PostgreSQL ... you should have passwords on the various accounts. ...
    (Debian-User)
  • Re: Access and Postgresql
    ... end on the same machine that is hosting the Postgresql program. ... If you have a split Access database with back-end (tables, data, and ... relationships) on the server, and the front-end (queries, forms, reports, ... the fact is they are _hoping_ that it is some other software interfering ...
    (comp.databases.ms-access)
  • Re: Ever thought about using PostgreSQL? Ever wonder what it is all about?
    ... But since Firebird is becoming a better ... me 4GB) database files, I don't have motivations to make a profound ... PostgreSQL's PLpgsql language. ... Not to mention that PostgreSQL has Schemas and things like DBI_link ...
    (borland.public.delphi.thirdpartytools.general)