Postgres ODBC and PostgreSQL 6.5.2

From: Cristiano Verondini <cverondini(at)deis(dot)unibo(dot)it>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Postgres ODBC and PostgreSQL 6.5.2
Date: 1999-10-12 16:16:42
Message-ID: 38035EEA.85AD049@deis.unibo.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello,

I have installed PostgreSQL 6.5.2 on my Linux box, and ODBC drivers for
Windows from http://www.insightdist.com/psqlodbc.

All seemed to work fine, that is I can connect tables using MsAccess,
and browse throught data.

But when I examined closer, I found some data is missing. This i s the
data structure I use:

CREATE TABLE WWork (
IDWork int4,
titolo CHAR(1000),
autori CHAR(1000),
affiliazione CHAR(1000),
sommario varchar(1024),
IDpertinenza int4,
autoreRiferimento CHAR(100),
emailRiferimento CHAR(100),
file1 CHAR(50),
file2 CHAR(50),
file3 CHAR(50),
file4 CHAR(50),
file5 CHAR(50),
demo INT4
) \g

Some of the data are missing (but I can see them using pgaccess on
linux), as titolo, autori, ... and some is truncated, such as sommario.

In the advanced options I saw 6.4 compatibility (not 6.5). May this be
a problem?

Any other idea?

Thanks in advance

Cris

Browse pgsql-interfaces by date

  From Date Subject
Next Message Chris Palermo 1999-10-12 16:17:03 Perl & Postgresql
Previous Message Allan Huffman 1999-10-12 14:27:59 SQL_ASCII Java Access