Apparently this is a known Oracle bug. I do not know the bug number,
but the first column gets dropped when selecting from multiple tables
or view (or some such bug - I got it secondhand from a friend). To
workaround I ask for a "faux" first column (i.e., one that I did not
care about) then ignore it.
rich_at_belarc.com (Dick DeFuria) wrote in message news:<e71ad920.0110311112.efac19c_at_posting.google.com>...
> Hello,
>
> I connect to Oracle 8i via ODBC using ADODB.RecordSet
> from JavaScript ASP pages from IIS5.
>
> When I use the 8.1.7.0 to 8.1.7.3 versions of the
> Oracle ODBC Driver, my results are fine.
>
> When I use the 8.1.7.4 Oracle ODBC Driver, however, my
> resultset contains one fewer columns than the other versions;
> one column is completely missing.
>
> I am at a loss to explain this behaviour.
>
> When I run my sql query via sql*plus or via Oracle ODBC Test
> utility, I get the correct results (i.e., all the columns
> show up in the results).
>
> Any ideas?
>
> TIA,
>
> -Dick
Received on Tue Nov 13 2001 - 14:48:11 CST
