From: Byron Nikolaidis <byronn@insightdist.com>
To: Len Morgan <len-morgan@xroadstx.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC Problem
Date: Fri, 10 Jul 1998 12:03:13 -0400
Message-ID: <35A63B41.CC2274D7@insightdist.com> (raw)
References: <005901bdab62$05df31e0$0908a8c0@H233>
> Len Morgan wrote:
>
> 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 have had this problem also, but for the life of me, I can't reproduce
it now. I remember though, when I had the problem, if I turned on
"Totals" and just had "Group By" for all the fields, it allowed me to
order by whatever I wanted. It *seems* like a bug in Access? Try that
and see if it at least has an effect.
Also, what version of the odbc driver are you using? And, can you
illustrate your query (what tables, joins, etc) so I could try to
reproduce it?
> 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?
>
Yes, I have this as well. I do not know any way to make Access save the
Data source with the query. As far as I can tell, it is not the driver
but Access forcing this behavior? Have you or anyone seen differently
with other databases like Oracle?
Byron
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: byronn@insightdist.com, len-morgan@xroadstx.com
Subject: Re: [INTERFACES] ODBC Problem
In-Reply-To: <35A63B41.CC2274D7@insightdist.com>
* 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