From: | Moray McConnachie <Moray(dot)McConnachie(at)computing-services(dot)oxford(dot)ac(dot)uk> |
---|---|
To: | Hiroki Kataoka <kataoka(at)interwiz(dot)koganei(dot)tokyo(dot)jp> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | RE: [INTERFACES] Access 2000 |
Date: | 1999-08-26 09:36:30 |
Message-ID: | EXECMAIL.990826103630.F@moraypc.computing-services.oxford.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(dot)McConnachie(at)computing-services(dot)oxford(dot)ac(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas Thomson | 1999-08-26 12:14:56 | Re: lo_read error ??? |
Previous Message | Constantin Teodorescu | 1999-08-26 09:24:48 | Re: [INTERFACES] pgAdmin v6.5.1 Release |