From: | "Israel Zavalza Bahena" <izavalza(at)hotmail(dot)com> |
---|---|
To: | cverondini(at)deis(dot)unibo(dot)it, pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2 |
Date: | 1999-10-12 13:22:03 |
Message-ID: | 19991012202204.17440.qmail@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)deis(dot)unibo(dot)it>
>To: pgsql-interfaces(at)postgreSQL(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Allan Huffman | 1999-10-12 13:41:13 | Testing 1-2-3 |
Previous Message | Allan Huffman | 1999-10-12 09:50:35 | HELP - Accessing SQL_ASCII from Java |