From: Dave Page <dpage@vale-housing.co.uk>
To: pgsql-interfaces@postgresql.org
Subject: Backend/PostODBC hanging and ADO2.0
Date: Thu, 10 Sep 1998 10:23:46 +0100
Message-ID: <000301bddc9c$b71ecd60$2801a8c0@pc81.vale-housing.co.uk> (raw)
Hi,
I have two problems which I just can't figure out and any help/ideas would
be greatly appreciated!
Problem 1.
As some of you know, I'm the author of pgAdmin (the PostgreSQL frontend for
windoze). pgAdmin is written in VB5/6 and uses DAO3.5 and PostODBC 6.3.0249.
I and a number of pgAdmin users have found that some queries (rarely the
same ones, and they could be a simple DROP TABLE or a complex SELECT) will
hang pgAdmin and sometimes the PostgreSQL backend as well. On closer
inspection of the PostODBC commlog I have found that invariably the query is
sent to the backend but no reply is received which I believe indicates a
problem with either PostODBC or the PostgreSQL backend (I think this is more
likely because it sometimes hangs as well).
I have check the SQL syntax etc. and found nothing odd or incorrect.
Problem 2.
This is more of a VB type question... I am in the process of moving to
Visual Studio 6 in which M$ seem to prefer the use of ADO2.0 over DAO3.5. I
have done a few tests and found that it seems to be a lot quicker and have
since written my own data control which works a treat with mdb files. With
PostgreSQL though, queries run nice and quickly, and I can build and
manipulate a recordset. However, when I try to edit a record, usually, the
first attempt of the day works fine, but subsequent attempts to edit records
fail at the recordset.update with the error:
Run-time Error '-2147467259 (80004005)':
Insufficient base table information for updating or refreshing
PostODBC's commlog shows no attempt to update the record. Could this be that
PostODBC is not supplying some info required by ADO? If so, I find it
strange that it will sometimes (rarely) work OK.
TIA for any help, and sorry for the loooonnnng post!
Dave.
--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk
Beer can be a permanent solution - but only if you have enough of it!
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: dpage@vale-housing.co.uk
Subject: Re: Backend/PostODBC hanging and ADO2.0
In-Reply-To: <000301bddc9c$b71ecd60$2801a8c0@pc81.vale-housing.co.uk>
* 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