Received: from mail2.xroadstx.com (xroadstx.com [208.220.74.12]) by hub.org
	(8.8.8/8.7.5) with ESMTP id NAA21917 for
	<pgsql-interfaces@postgresql.org>;
	Thu, 9 Jul 1998 13:51:24 -0400 (EDT)
Received: from H233 (mnet01-20.xroadstx.com [208.234.65.39])
	by mail2.xroadstx.com (8.8.8/8.8.8) with SMTP id MAA23155
	for <pgsql-interfaces@postgresql.org>;
	Thu, 9 Jul 1998 12:51:21 -0500 (CDT)
Message-ID: <005901bdab62$05df31e0$0908a8c0@H233>
From: "Len Morgan" <len-morgan@xroadstx.com>
To: <pgsql-interfaces@postgresql.org>
Subject: ODBC Problem
Date: Thu, 9 Jul 1998 12:50:11 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0056_01BDAB38.1C25CEC0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

This is a multi-part message in MIME format.

------=_NextPart_000_0056_01BDAB38.1C25CEC0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have successfully connected to PostgreSQL from Access97 and have even =
been able to make a query that gets it's results from several tables all =
at once.  The problem is that no matter what I do, the ORDER BY clause =
of the query is ignored.  I have set the sort criteria and I have tried =
with a pass-through query but the sorting always seems to come out in =
the order of the subtables that are joined to my main table.

I also have had a problem where I want to write a pass-through query but =
can't get it to execute without bringing up the "Select Data Source" =
dialog box.  We are only ever going to use one data source and I know =
what it is so why do I get this message EVERY time I run the query?  Is =
there some way to specify the DSN in the pass-through query so that I =
don't have to have my users do this everytime?

Thanks for your help,

len morgan

------=_NextPart_000_0056_01BDAB38.1C25CEC0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>I have successfully connected to =
PostgreSQL from=20
Access97 and have even been able to make a query that gets it's results =
from=20
several tables all at once.&nbsp; The problem is that no matter what I =
do, the=20
ORDER BY clause of the query is ignored.&nbsp; I have set the sort =
criteria and=20
I have tried with a pass-through query but the sorting always seems to =
come out=20
in the order of the subtables that are joined to my main =
table.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2>I also have had a problem where I =
want to write=20
a pass-through query but can't get it to execute without bringing up the =

&quot;Select Data Source&quot; dialog box.&nbsp; We are only ever going =
to use=20
one data source and I know what it is so why do I get this message EVERY =
time I=20
run the query?&nbsp; Is there some way to specify the DSN in the =
pass-through=20
query so that I don't have to have my users do this =
everytime?</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2>Thanks for your help,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2>len =
morgan</FONT></DIV></BODY></HTML>

------=_NextPart_000_0056_01BDAB38.1C25CEC0--