<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16762" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=039570318-12122008><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=039570318-12122008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=039570318-12122008><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=039570318-12122008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=039570318-12122008><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=039570318-12122008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=039570318-12122008><FONT face=Arial size=2>Is there any extra
debug information I can get from the ODBC driver to see where the failure
is?</FONT></SPAN><SPAN class=039570318-12122008><FONT face=Arial
size=2></FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>Stanley Sufficool</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Systems Analyst</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>San Bernardino County</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>909-387-2102</FONT></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><SPAN
style="FONT-SIZE: 18pt; COLOR: green; FONT-FAMILY: Webdings">P</SPAN><SPAN
style="FONT-SIZE: 18pt; COLOR: green; FONT-FAMILY: 'Courier New'"> </SPAN><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">
</SPAN><SPAN
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Arial','sans-serif'">Please
consider the environment before printing this e-mail or its
attachment(s)</SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>