From: | "Len Morgan" <len-morgan(at)xroadstx(dot)com> |
---|---|
To: | <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | ODBC Problem |
Date: | 1998-07-09 17:50:11 |
Message-ID: | 005901bdab62$05df31e0$0908a8c0@H233 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Anil Amarakoon | 1998-07-09 18:36:08 | Re: [INTERFACES] a JDBC applet |
Previous Message | Peter T Mount | 1998-07-09 17:15:40 | Re: [INTERFACES] PostgreSql-users and passwords |