Re: Problems querying memo fields

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello Paul,
"Paul Hansson" <PaulHansson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

PH> Hello There,
PH>
PH> I wonder if someone can clear up a problem I am having. We have a
PH> system under development which is heavily dependent on an existing
PH> MS Access database. Some of the queries in the Access version of
PH> the application query Memo fields and they work fine within Access.
PH>
PH> If I try to use exactly the same query from an ASP/Vbscript web
PH> page the query does not return the expected results. I am using ADO
PH> and an ODBC DSN connection, all of the other queries seem to work
PH> fine.
PH>
PH> I have a vague recollection of being told that you can not query
PH> Memo fields through an ODBC DSN, or that not all of the Memo field
PH> is queried, only the first 255 characters. Can anyone confirm this
PH> is true. I have tried searching the web, and some references that I
PH> have available, but it seems that there is nothing out there to
PH> confirm my suspicions.

Columns of the type Memo work fine via the Access ODBC driver. More exactly,
the data type is called LONGTEXT there.

I cannot say anything about ASP/Vbscript/ADO.
--
Sincerely,
Dmitriy Ivanov
Common Lisp ODBC interface - lisp.ystok.ru/ysql.html


.

Quantcast