Skip site navigation (1) Skip section navigation (2)

Re: MS Access problem with memos

From: "Sim Zacks" <sim(at)nospam(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: MS Access problem with memos
Date: 2005-01-11 14:08:56
Message-ID: cs0mol$181n$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
1) In order to get Access to recognize the datatype, you have to delete the
linked table and relink it. Nothing else helps, even choosing a new location
in the linked table manager.
2) I believe that in my testing the ODBC driver for version 8, which was a
snapshot version, worked with the Text as LongVarChar. the stable version
worked the opposite. (I could be wrong about this)

"Jeff Eckermann" <jeff_eckermann(at)yahoo(dot)com> wrote in message
news:20050110210030(dot)36073(dot)qmail(at)web20825(dot)mail(dot)yahoo(dot)com(dot)(dot)(dot)
> --- Zanoni Marco <postgresql(at)innysoft(dot)com> wrote:
>
> > Hi,
> > I have a problem with the ODBC driver and MS Access
> > XP.
> > If I have a table on PostgreSQL ( version 7.4.6)
> > with text column,
> > MS Access reads it as a varchar(254) column, instead
> > of a "Memo" dataytpe.
> >
> > The official doccumentation says that the driver
> > option "Text as
> > LongVarchar" should map text as memos, but it
> > doesn't work.
>
> Works for me.  Did you remember to relink the table(s)
> after you made that change?  (The Linked Table Manager
> might be enough).
>
> >
> > I read an old workaround to make this work, but it
> > says to create a new type,
> > and since 7.4 it must be coded in C. Is it the only
> > way?
> >
> > I work on Windows 2000, the latest official version
> > of the driver, and
> > PostgreSQL 7.4.6 on Gentoo Linux.
> >
> > Do anyone know why it doesn't work?
> >
> > Thanks for your help.
> >
> > Regards,
> >
> > Zanoni Marco
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose
> > an index scan if your
> >       joining column's datatypes do not match
> >
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Meet the all-new My Yahoo! - Try it today!
> http://my.yahoo.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>



In response to

pgsql-odbc by date

Next:From: Merlin MoncureDate: 2005-01-12 15:33:21
Subject: Re: Query with hexadecimal characters
Previous:From: LucianoDate: 2005-01-11 02:36:16
Subject: Re: Query with hexadecimal characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group