Message-ID: <19991012202204.17440.qmail@hotmail.com>
From: "Israel Zavalza Bahena" <izavalza@hotmail.com>
To: cverondini@deis.unibo.it, pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2
Date: Tue, 12 Oct 1999 13:22:03 PDT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

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


>From: Cristiano Verondini <cverondini@deis.unibo.it>
>To: pgsql-interfaces@postgreSQL.org
>Subject: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2
>Date: Tue, 12 Oct 1999 18:16:42 +0200
>
>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
>
>************
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com