From: Cristiano Verondini <cverondini@deis.unibo.it>
To: pgsql-interfaces@postgreSQL.org
Cc: Israel Zavalza Bahena <izavalza@hotmail.com>
Subject: Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2
Date: Sat, 16 Oct 1999 14:33:07 +0200
Message-ID: <38087083.6CC7A6AC@deis.unibo.it> (raw)
References: <19991012202204.17440.qmail@hotmail.com>
> > 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.
Israel Zavalza Bahena wrote:
> In the ODBC Driver Advanced Options you can change the max size of data
> as much as 4096 bytes.
>
> Check that. It should be the problem
I rised the limits, but this doesn't solve my problem. I found data in
fields from Access is all of blank char (0x20) for field 'autori'.
Any other idea?
Cris
--
Cristiano Verondini
http://www.ing.unibo.it/~cverond
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: cverondini@deis.unibo.it, izavalza@hotmail.com
Subject: Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2
In-Reply-To: <38087083.6CC7A6AC@deis.unibo.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox