Re: Pass-through query drops each 256th character?

It sounds like you've run into a genuine Access bug, and it's probably documented on-line. I can't tell you a fix, but I can suggest a workaround.

Use a stored procedure to run your query, but store the results in a table on the server-side that can then be queried by Access to see the result. If this is a multi-user situation, you can add a field to the primary key of the result table that can be used to identify the session running the SP, and retrieving the results.

Mike deFreitas <MdeFreitasNOSPAM_at_whistlercomputing.com> wrote in article <35D05A05.C1126654_at_whistlercomputing.com>...
> I will be forever in debt to the person who provides a solution to this
> problem*:
>
> I am trying to execute the following pass-through query (in Access 2.0)
> against an Oracle (7.3.4) database:
>
> SELECT field1 FROM tablename
>
> Pretty simple, eh? OK, field1 is defined as varchar(2000) and contains
> a lot of text, frequently the full 2000 characters. When I run the
> query, every 256th character in field1 is dropped. That is, if field1
> contained:
>
> "blah blah blah......this asterisk * is character 256......blah blah
> blah"
>
> then the result of the query would be:
>
> "blah blah blah......this asterisk is character 256.......blah blah
> blah"
>
> If I open the table (as an attached table) in datasheet mode, the data
> looks fine. If I run a standard Jet query (instead of pass-through),
> the data looks fine. If I use ODBCTest to run the Oracle SQL, the data
> comes back fine. It only seems to happen when the query is a
> pass-through. If the field has exactly 256 characters, the last one
> will be dropped; if it has 2000 characters, every 256th will be tossed.
> This also affects fields defined as Oracle type LONG (this is like a
> Memo for you Access people).
>
> Note: the actual query causing me problems is significantly more
> complex than this example and due to that and other reasons, I MUST use
> a pass-through query so please don't suggest "Just use a Jet query".
>
> OK, so, has anybody seen this before? Any solutions?
>
> Thanks in advance!
>
> *When I say "I will be forever in debt to" I mean "I will not say nasty
> things about".
>
> ==
> == Mike deFreitas
> == Whistler Computing, LLC
> == (Remove the 'NOSPAM' from my address when replying)
> ==
>
>
>
  Received on Tue Aug 11 1998 - 00:00:00 CDT