Access 2002 linked table behavior

This is a multi-part message in MIME format.

--===============0357604019==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C95C8C.1B9EFBB0"

This is a multi-part message in MIME format.

------_=_NextPart_001_01C95C8C.1B9EFBB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I am debugging a certain application *cough* ArcGIS *cough* using Access
2002 linked tables and PostgreSQL. I am able to get the application to
recognize and work with SQL 2005 linked tables, but it won't with
PostgreSQL linked tables.
=20
I have traced all commands going to PG using the pgodbc debug logs and
all the queries are fine. So, now I am left with the ODBC / DAO layers.
I think this has something to do with MSSQL IMAGE versus the PG bytea
type since when it get to handling the bytea blobs, this is where it
seems to crash. I have verified at the DAO layer that all data types and
table/field attributes match between MSSQL and PGSQL linked tables.
=20
If I trick the app by allowing initial connect to the SQL linked tables
and then swap the link for the PG table all goes just fine and I can see
the queries passed to PG and drawn on the application screen, but I cant
get the app to do the initial connect to the PG linked table.
=20
Is there any extra debug information I can get from the ODBC driver to
see where the failure is?
=20
Stanley Sufficool
Systems Analyst
San Bernardino County
909-387-2102
=20
P Please consider the environment before printing this e-mail or its
attachment(s)
=20

------_=_NextPart_001_01C95C8C.1B9EFBB0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



charset=3Dus-ascii">