From: Len Morgan <len-morgan@xroadstx.com>
To: pgsql-interfaces@postgresql.org
Subject: ODBC Problem
Date: Thu, 9 Jul 1998 12:50:11 -0500
Message-ID: <005901bdab62$05df31e0$0908a8c0@H233> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: len-morgan@xroadstx.com
Subject: Re: ODBC Problem
In-Reply-To: <005901bdab62$05df31e0$0908a8c0@H233>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox