From: Byron Nikolaidis <byronn@insightdist.com>
To: Len Morgan <len-morgan@xroadstx.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC Problem
Date: Tue, 21 Jul 1998 18:19:17 -0400
Message-ID: <35B513E5.729800C5@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.
>
We have learned a few things about the Microsoft Jet Engine since this
mail. Access uses "dynasets" to handle data in query recordsets. If
you don't need to update values in your queries, you can use a
"snapshot" recordset, which can be faster. It also may help your
order-by random problem. To do this in Access, try bringing up the
"design view" of your query. Then right click and you should get a
"Query Properties" box. There is a field called "RecordSet Type" which
probably says Dynaset. If you set this to "Snapshot", your problem may
go away.
> 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?
>
This one we definately have figured out. When looking at your pass-thru
query, go to "View" then "Properties" in Access. This will bring up a
box of properties. There is one called "ODBC Connect Str" and it should
be defaulted to "ODBC;". Simply add "DSN=<your_datasource>" after the
ODBC part and it won't keep asking you.
Hope this is helpful.
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: <35B513E5.729800C5@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