Received: from smtp-out2.bellatlantic.net (smtp-out2.bellatlantic.net
	[199.45.39.157]) by hub.org (8.9.1/8.9.1) with ESMTP id SAA11861
	for <pgsql-interfaces@postgreSQL.org>;
	Sat, 23 Jan 1999 18:39:27 -0500 (EST)
	(envelope-from daybee@bellatlantic.net)
Received: from daveh (client-151-196-125-2.bellatlantic.net [151.196.125.2])
	by smtp-out2.bellatlantic.net (8.9.1/8.9.1) with SMTP id SAA07042;
	Sat, 23 Jan 1999 18:40:27 -0500 (EST)
Message-ID: <007f01be4729$98382480$027dc497@daveh>
From: "David Hartwig" <daybee@bellatlantic.net>
To: "Gregg Berkholtz" <gregg@gbcomputers.com>,
	"Access Developer listserv" <accessd@mtgroup.com>,
	"Postgres interface list" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] MS Access 97 and Pass-through SQL
Date: Sat, 23 Jan 1999 18:39:13 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.0810.800
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800

Any legal PostgreSQL statement(s) should work.  However, I don't think
multiple resultset are allowed.  The big thing is that you are avoiding the
MS Jet Engine.  This will allow you access any non-standard functions and
syntax available to PostgreSQL.

If you don't know, Jet has many benifits.  Like performing outer joins and
cross-tabulation.

----- Original Message -----
From: Gregg Berkholtz <gregg@gbcomputers.com>
To: Access Developer listserv <accessd@mtgroup.com>; Postgres interface list
<pgsql-interfaces@postgreSQL.org>
Sent: Saturday, January 23, 1999 3:08 PM
Subject: [INTERFACES] MS Access 97 and Pass-through SQL


>Does anyone know what pass-through SQL statements cannot be used with
>PostgreSQL connections via ODBC.
>I am running PostgreSQL 6.4.2.
>
>Thanks greatly!
>
>Gregg Berkholtz
>
>