This is great. Unfortunately I don't do any compiling work
on the Win platform - could someone send me a recompiled
version of the relevant dll, by any chance?
Alternatively, I note that someone mentioned ODBC driver
6.40.00007 (or whatever) - does anyone know
a) where I can get this
b) if it includes the tweak for Access
Thanks,
Moray
> If SQL_ORDER_BY_COLUMNS_IN_SELECT is "Y" in SQLGetInfo, then Access2000 fail
> to link ODBC tables. For verification, I modified PsqlODBC source, compiled
> it, and tried to use with Access2000. This try has been done successfully.
>
> % diff info.c.orig info.c
> 421c421
> < p = "Y";
> ---
> > p = (PROTOCOL_62(ci) || PROTOCOL_63(ci)) ? "Y" : "N";
>
> This solution was got by comparison of SQL.LOG between some ODBC
> drivers(ORACLE, Informix, MSSQL and PsqlODBC). There is no other grounds. I
> don't know why this is good.
>
> =====
> Hiroki Kataoka
>
----------------------
Moray.McConnachie@computing-services.oxford.ac.uk