Re: [INTERFACES] new odbc fails

From: David Hartwig <daveh(at)insightdist(dot)com>
To: "John J(dot) Boris, Sr(dot)" <john(dot)boris(at)onlinesvc(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] new odbc fails
Date: 1998-08-26 12:47:12
Message-ID: 35E403CF.9B811F3D@insightdist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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?

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message David Hartwig 1998-08-26 12:54:28 Re: [SQL] excel vs. money data type?
Previous Message Sferacarta Software 1998-08-26 11:27:50 Re[2]: [GENERAL] Set DATESTYLE='ISO' (Postgres 6.3.2)