Thread: Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2

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

> >       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