Message-Id: <36546DAF.E6E5C793@insightdist.com>
Date: Thu, 19 Nov 1998 14:12:48 -0500
From: David Hartwig <daveh@insightdist.com>
Organization: Insight Distribution Systems
Mime-Version: 1.0
To: Warren Craig <CWarren@iclretail.com>
Cc: "'pgsql-interfaces@postgresql.org'" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] POSTOBDC
References: <BF1813FE1ACFD111BACA00A0C9B3C13BC7ABC1@usa04s00010.iclretail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Warren Craig wrote:

>         I have set up a couple of tables on Postgresql and I have installed
> PostODBC drivers on my NT 4.0 machine.  I have been testing out the drivers
> by using MSQuery tool.  In that tool if I pick the datasource as Postgres I
> get a list of tables, I can select a table and it shows all the columns for
> that table, but if I do a "Select *"  for that table it doesn't work
> correctly.  The only thing that I get back is the field "xmin" and no other
> fields.  Any help would be appreciated.  Has anybody got Access to link
> tables through PostODBC drivers correctly?
>

Both MS Query and MS Access are fairly routine setups.

What version of driver?   PostgreSQL?

Could you send a log file?      Activate CommLog in the driver and send
C:/psqlodbc_#######.log   Where ##### is the PID.