Project Openings

PostgreSQL OLE DB provider for Windows

[#1008968] No Columns Defined in Rowset

View Trackers | Bugs | Download .csv | Monitor

Date:
2007-09-20 12:43 Priority:
3

State:
Open

Submitted by:
Matthew Radcliffe (mradcliffe) Assigned to:
Nobody (None)

Category:
Incorrect behavior Group:

Resolution:
None

Summary:
No Columns Defined in Rowset

Detailed description
I did not see this reported anywhere, but I have PostgreSQL OLE DB Provider v1.0.0.20 returning errors for queries that work. I'm not the usual VB or Windows programmer, but I am hacking a simple vb/access time clock for a company (oracle -> postgre). The code is not mine, but basically here's what happens to reproduce the error. We open up a new ADODB connection as well as a new recordsets. If there's an error it handles it by printing out the error (number, description, and I also added the actual query). The app makes a connection to a postgresql database and either inserts into 2 tables or inserts into one and deletes out of the other. The former inserts require a nextval() function to be called. Any INSERT or DELETE statement throws an error - "No columns defined in rowset" However our oledb driver is functioning fine, we have made both queries. In order to ignore these "error" messages I've disabled the error handling in the app, but this isn't a solution that I stand behind. This message should be a debug/warning message, not an error message. Is this error coming over from oledb.h? I can't find anything in the source here. The Logfile doesn't seem to be giving me any specific debug information for the delete and insert queries. If this is really a bug in oledb.h please close, and then at least we have a solution of just not listening to the error messages. ;-)

Followup

No Followups Have Been Posted

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge