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.
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.
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.
Is there any extra debug information I can get from the ODBC driver to
see where the failure is?
Stanley Sufficool
Systems Analyst
San Bernardino County
909-387-2102
P Please consider the environment before printing this e-mail or its
attachment(s)
------_=_NextPart_001_01C95C8C.1B9EFBB0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16762" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D039570318-12122008><FONT face=3DArial size=3D2>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=3D039570318-12122008><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D039570318-12122008><FONT face=3DArial size=3D2>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=3D039570318-12122008><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D039570318-12122008><FONT face=3DArial size=3D2>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=3D039570318-12122008><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D039570318-12122008><FONT face=3DArial size=3D2>Is =
there any extra
debug information I can get from the ODBC driver to see where the =
failure
is?</FONT></SPAN><SPAN class=3D039570318-12122008><FONT face=3DArial
size=3D2></FONT></SPAN></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Stanley =
Sufficool</FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Systems =
Analyst</FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>San Bernardino =
County</FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>909-387-2102</FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV align=3Dleft><SPAN
style=3D"FONT-SIZE: 18pt; COLOR: green; FONT-FAMILY: =
Webdings">P</SPAN><SPAN
style=3D"FONT-SIZE: 18pt; COLOR: green; FONT-FAMILY: 'Courier =
New'"> </SPAN><SPAN
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
'Arial','sans-serif'">
</SPAN><SPAN
style=3D"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=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------_=_NextPart_001_01C95C8C.1B9EFBB0--
--===============0357604019==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
postgis-users mailing list
postgis-users [at] postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-user s
--===============0357604019==--
