pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2
3+ messages / 2 participants
[nested] [flat]
* Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2
@ 1999-10-12 13:22 Israel Zavalza Bahena <izavalza@hotmail.com>
1999-10-16 12:33 ` Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2 Cristiano Verondini <cverondini@deis.unibo.it>
0 siblings, 1 reply; 3+ messages in thread
From: Israel Zavalza Bahena @ 1999-10-12 13:22 UTC (permalink / raw)
To: cverondini@deis.unibo.it; 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@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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2
1999-10-12 13:22 Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2 Israel Zavalza Bahena <izavalza@hotmail.com>
@ 1999-10-16 12:33 ` Cristiano Verondini <cverondini@deis.unibo.it>
0 siblings, 0 replies; 3+ messages in thread
From: Cristiano Verondini @ 1999-10-16 12:33 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Israel Zavalza Bahena <izavalza@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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Postgres ODBC and PostgreSQL 6.5.2
@ 1999-10-12 16:16 Cristiano Verondini <cverondini@deis.unibo.it>
0 siblings, 0 replies; 3+ messages in thread
From: Cristiano Verondini @ 1999-10-12 16:16 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-10-16 12:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-12 13:22 Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2 Israel Zavalza Bahena <izavalza@hotmail.com>
1999-10-16 12:33 ` Cristiano Verondini <cverondini@deis.unibo.it>
1999-10-12 16:16 Postgres ODBC and PostgreSQL 6.5.2 Cristiano Verondini <cverondini@deis.unibo.it>
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