MS Access via ODBC

From: "Taral" <taral(at)mail(dot)utexas(dot)edu>
To: <pgsql-sql(at)hub(dot)org>
Subject: MS Access via ODBC
Date: 1998-08-09 18:47:30
Message-ID: 000001bdc3c6$299f7960$3b291f0a@taral
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I noticed that when trying to get MS Access to do a query of "SELECT * FROM
table ORDER BY somekey" as its data source for a form, it actually issues
"SELECT primarykey FROM table ORDER BY somekey", which PostgreSQL rejects
because "somekey" isn't being selected.

Now, either PostgreSQL has put an (odd) restriction on SQL, or MS Access is
issuing an invalid SQL query. Which one is it?

Taral

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stuart logan 1998-08-10 09:01:22 Installing PostgreSQL 6.3.2 On Linux
Previous Message Johann Spies 1998-08-07 08:55:40 Re: [SQL] What is the recommended machine configuration?