From: Scott Holmes <sholmes@pacificnet.net>
To: pgsql-interfaces@postgresql.org
Subject: Transactions and Errors with ODBC
Date: Wed, 18 Oct 2000 09:54:25 -0700
Message-ID: <200010181654.JAA32210@scotts.mynetwork.net> (raw)
I've just joined this list, after scanning through the recent archives, to ask
this question. I have been unable to control transactions and locks through
an ODBC connection. I have also been unable to obtain meaningful error
values. Now, my problem may very well be with the interface I'm using,
Passport 4GL, which few if any of you have probably heard of. I'm using
postdrv 6.5 from Insight Distribution Systems on an NT 4.0. My server is
RH6.2 with PostgreSQL 7.0.2. I have not had any difficulty with "normal"
database interaction; ie select/add/update/delete.
In regards to transactions: I have been unable to lock a row for update nor
has rollback worked. These do function normally with psql and with PG Access
on the server.
In regards to error messages: The value returned to my program is always 1.
I've been testing by trying to insert and update a duplicate value in a unique
field. The insert and update does error as it should but I would also like to
provide the user with a meaningful message as to why.
Are these known conditions with ODBC or do I need to deal with my interface
package?
Thanks,
Scott
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: sholmes@pacificnet.net
Subject: Re: Transactions and Errors with ODBC
In-Reply-To: <200010181654.JAA32210@scotts.mynetwork.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