Re: [INTERFACES] MS Access 97 and Pass-through SQL

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: [INTERFACES] MS Access 97 and Pass-through SQL
Дата
Msg-id 19990124100526.B2474@gmx.net
обсуждение исходный текст
Ответ на MS Access 97 and Pass-through SQL  (Gregg Berkholtz <gregg@gbcomputers.com>)
Список pgsql-interfaces
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!

В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: [INTERFACES] MS Access 97 and Pass-through SQL
Следующее
От: Glenn Holmer
Дата:
Сообщение: Re: [INTERFACES] JDBC throws with error code 0