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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2005-01-12 15:33:21 | Re: Query with hexadecimal characters |
Previous Message | Luciano | 2005-01-11 02:36:16 | Re: Query with hexadecimal characters |