From: Michael Meskes <Michael_Meskes@usa.net>
To: Postgres interface list <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] MS Access 97 and Pass-through SQL
Date: Sun, 24 Jan 1999 10:05:26 +0100
Message-ID: <19990124100526.B2474@gmx.net> (raw)
In-Reply-To: <36AA2C30.E3A48693@gbcomputers.com>
References: <36AA2C30.E3A48693@gbcomputers.com>
On Sat, Jan 23, 1999 at 12:08:16PM -0800, Gregg Berkholtz wrote:
> Does anyone know what pass-through SQL statements cannot be used with
> PostgreSQL connections via ODBC.
> I am running PostgreSQL 6.4.2.
I'm not sure you can run pass-through queries that return something. I think
it's like an execute immediate in embedded SQL, i.e. no return values.
Also be very careful when trying to access this table from C or Basic.
Access itself passes the statement through to the original DB, but when
programmin the jet engine the statement is passed through to Access! So
don't be surprised if your performance goes downhill.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net | Use PostgreSQL!
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: Michael_Meskes@usa.net
Subject: Re: [INTERFACES] MS Access 97 and Pass-through SQL
In-Reply-To: <19990124100526.B2474@gmx.net>
* 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