ODBC Problem
| От | Len Morgan |
|---|---|
| Тема | ODBC Problem |
| Дата | |
| Msg-id | 005901bdab62$05df31e0$0908a8c0@H233 обсуждение исходный текст |
| Список | 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
В списке pgsql-interfaces по дате отправления: