Message-Id: <35E403CF.9B811F3D@insightdist.com>
Date: Wed, 26 Aug 1998 08:47:12 -0400
From: David Hartwig <daveh@insightdist.com>
Organization: Insight Distribution Systems
Mime-Version: 1.0
To: "John J. Boris, Sr." <john.boris@onlinesvc.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] new odbc fails
References: <199808260313.XAA27714@hub.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


John J. Boris, Sr. wrote:

> I downloaded and installed the new odbc driver. I am running WIndows NT 4.0
> and my PostreSQL is on a LINUX box. I can connect to the database using MS
> Access 97, link the tables, it allows me to select unique keys for each
> table but when I try to view a table I get an ODBC failed message and the
> table is filled with NAME#.

I need a little more information.

    Version of PostgreSQL server?

    Version of ODBC Driver?   I know you say you have the latest, but we have
had some confusion  in the past with old FTP sites.

Could you turn the CommLog under the Advanced Driver Options and send the
results of your interaction.   The log file is C:\psqlodbc.log.   You must
close the application before the logging activity is flushed.

>
>
> I have the user set to postgres abnd the correct password.
> Any ideas as to why I can't see any of the data from my table or can't I
> link the MS Access table to the PostgreSQL?