Skip site navigation (1) Skip section navigation (2)

Access 97 - problems with the result set

From: "Joseph" <lters(at)mrtc(dot)com>
To: "Pgsql-Odbc(at)Postgresql(dot)Org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Access 97 - problems with the result set
Date: 2001-07-21 11:19:25
Message-ID: JBEPLLKEDKIHJBCHDDOGAEGOCFAA.lters@mrtc.com (view raw or flat)
Thread:
Lists: pgsql-odbc
I am running access queries and it seems that it thinks certain queries were
unsuccessful when in fact they were successful...!

Is there something special that access expects to get back which indicates a
successful query?

Of course access appends the horrid select * from to the front of the query
and then postgres promptly gives and error.

Access then reports an error. Even though the original query executed fine
on the server.

Postgres 7.1.2
odbc 7.01.0006
win2k is the client


respectfully,
Joseph


Responses

pgsql-odbc by date

Next:From: JosephDate: 2001-07-21 11:43:45
Subject: RE: Access 97 - problems with the result set
Previous:From: Enrico GavaDate: 2001-07-21 09:12:47
Subject: RE: [ODBC] ODBC performance with ADO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group