pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC: 'Insufficient base table information for updating or refres hing' error with ADO
5+ messages / 2 participants
[nested] [flat]
* ODBC: 'Insufficient base table information for updating or refres hing' error with ADO
@ 1999-10-15 13:01 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Dave Page @ 1999-10-15 13:01 UTC (permalink / raw)
To: pgsql-interfaces
Having migrated pgAdmin and some of my other apps to ADO from DAO, I am now
getting an "Insufficient base table information for updating or refreshing"
error under certain circumstances when trying to edit a recordset. My first
experiments with ADO had a similar problem which Byron fixed - I believe ADO
was requesting extended info that the driver couldn't supply.
The current problem occurs when an update, add or delete is attemped, if
the ADO command type is text (eg. an SQL query), but not if the command type
is table (eg. you just give ADO a table name).
The attached logs were created with a test program which executed a 'SELECT
oid, * FROM ca_event;' and then attempted to delete the first record that
was returned in the recordset.
Thanks in advance for any help...
Regards,
Dave.
<<psqlodbc.log>> <<SQL.LOG>>
--
Network & Systems Manager, The Vale Housing Association.
<http://www.vale-housing.co.uk; (Work)
<http://www.pgadmin.freeserve.co.uk; (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
Attachments:
psqlodbc.log (application/octet-stream, 4.0K) download
SQL.LOG (application/octet-stream, 58.4K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* ODBC: 'Insufficient base table information for updating or refres hing' error with ADO
@ 1999-10-15 15:15 Dave Page <dpage@vale-housing.co.uk>
1999-10-15 18:13 ` RE: [INTERFACES] ODBC: 'Insufficient base table information for updating or refreshing' error with ADO Thomas Byrnes <tbyrnes@helioshealth.com>
0 siblings, 1 reply; 5+ messages in thread
From: Dave Page @ 1999-10-15 15:15 UTC (permalink / raw)
To: pgsql-interfaces
Having migrated pgAdmin and some of my other apps to ADO from DAO, I am now
getting an "Insufficient base table information for updating or refreshing"
error under certain circumstances when trying to edit a recordset. My first
experiments with ADO had a similar problem which Byron fixed - I believe ADO
was requesting extended info that the driver couldn't supply.
The current problem occurs when an update, add or delete is attemped, if
the ADO command type is text (eg. an SQL query), but not if the command type
is table (eg. you just give ADO a table name).
The attached log created with a test program which executed a 'SELECT oid, *
FROM ca_event;' and then attempted to delete the first record that was
returned in the recordset. I do have the associated ODBC trace log as well
if required, but the listserver bounced it so I'll have to mail it to anyone
who may need it.
Thanks in advance for any help...
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
<<psqlodbc.log>>
Attachments:
psqlodbc.log (application/octet-stream, 4.0K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] ODBC: 'Insufficient base table information for updating or refreshing' error with ADO
1999-10-15 15:15 ODBC: 'Insufficient base table information for updating or refres hing' error with ADO Dave Page <dpage@vale-housing.co.uk>
@ 1999-10-15 18:13 ` Thomas Byrnes <tbyrnes@helioshealth.com>
0 siblings, 0 replies; 5+ messages in thread
From: Thomas Byrnes @ 1999-10-15 18:13 UTC (permalink / raw)
To: 'Dave Page' <dpage@vale-housing.co.uk>; pgsql-interfaces
Dave,
Are you locking the record set directly with ADO? If so, it may just be a
cursor problem.
Regards,
Tom
-----Original Message-----
From: owner-pgsql-interfaces@postgreSQL.org
[mailto:owner-pgsql-interfaces@postgreSQL.org] On Behalf Of Dave Page
Sent: Friday, October 15, 1999 11:16 AM
To: 'pgsql-interfaces@postgresql.org'
Subject: [INTERFACES] ODBC: 'Insufficient base table information for
updating or refreshing' error with ADO
<< File: psqlodbc.log >> Having migrated pgAdmin and some of my other apps
to ADO from DAO, I am now
getting an "Insufficient base table information for updating or refreshing"
error under certain circumstances when trying to edit a recordset. My first
experiments with ADO had a similar problem which Byron fixed - I believe ADO
was requesting extended info that the driver couldn't supply.
The current problem occurs when an update, add or delete is attemped, if
the ADO command type is text (eg. an SQL query), but not if the command type
is table (eg. you just give ADO a table name).
The attached log created with a test program which executed a 'SELECT oid, *
FROM ca_event;' and then attempted to delete the first record that was
returned in the recordset. I do have the associated ODBC trace log as well
if required, but the listserver bounced it so I'll have to mail it to anyone
who may need it.
Thanks in advance for any help...
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
<<psqlodbc.log>>
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] ODBC: 'Insufficient base table information for u pdating or refreshing' error with ADO
@ 1999-10-18 08:39 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Dave Page @ 1999-10-18 08:39 UTC (permalink / raw)
To: 'tbyrnes@helioshealth.com' <tbyrnes@helioshealth.com>; +Cc: pgsql-interfaces
Thanks Tom. Using Server Side cursors solves the immediate problem (as long
as I remember not to put a semi colon on then end of the query!).
Unfortunately though, this means that the recordset must be refreshed to
view newly added records which is not the case when using Client Side
cursors with a command type of Table. Anyone got any ideas?
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
> -----Original Message-----
> From: Thomas Byrnes [mailto:tbyrnes@helioshealth.com]
> Sent: 15 October 1999 18:13
> To: 'Dave Page'; 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] ODBC: 'Insufficient base table
> information for
> updating or refreshing' error with ADO
>
>
> Dave,
> Are you locking the record set directly with ADO? If
> so, it may just be a
> cursor problem.
>
> Regards,
>
> Tom
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] ODBC: 'Insufficient base table information for u pdating or refreshing' error with ADO
@ 1999-10-18 15:21 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Dave Page @ 1999-10-18 15:21 UTC (permalink / raw)
To: pgsql-interfaces
Just for information (in case anyone is interested), I have now solved this
problem. In a nutshell, ADO does not like trailing semi-colons on queries.
eg.
SELECT * FROM tablename;
will give an 'Insufficient base table information for updating or
refreshing' error, when updating the resulting recordset, but
SELECT * FROM tablename
will not.
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
> -----Original Message-----
> From: Dave Page [mailto:dpage@vale-housing.co.uk]
> Sent: 18 October 1999 08:40
> To: 'tbyrnes@helioshealth.com'
> Cc: 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] ODBC: 'Insufficient base table
> information for
> u pdating or refreshing' error with ADO
<SNIP>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-10-18 15:21 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-15 13:01 ODBC: 'Insufficient base table information for updating or refres hing' error with ADO Dave Page <dpage@vale-housing.co.uk>
1999-10-15 15:15 ODBC: 'Insufficient base table information for updating or refres hing' error with ADO Dave Page <dpage@vale-housing.co.uk>
1999-10-15 18:13 ` RE: [INTERFACES] ODBC: 'Insufficient base table information for updating or refreshing' error with ADO Thomas Byrnes <tbyrnes@helioshealth.com>
1999-10-18 08:39 RE: [INTERFACES] ODBC: 'Insufficient base table information for u pdating or refreshing' error with ADO Dave Page <dpage@vale-housing.co.uk>
1999-10-18 15:21 RE: [INTERFACES] ODBC: 'Insufficient base table information for u pdating or refreshing' error with ADO Dave Page <dpage@vale-housing.co.uk>
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