"Multiple-step OLE DB operation generated errors" in pgAdmin II:frmSQLOutput.LoadGrid

From: "Thomas Sandford" <thomas(at)paradisegreen(dot)co(dot)uk>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: "Multiple-step OLE DB operation generated errors" in pgAdmin II:frmSQLOutput.LoadGrid
Date: 2002-06-21 21:53:25
Message-ID: 01a701c2196e$12266bc0$0300000a@paradise
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-hackers pgsql-odbc

I am getting the error message

"Error in pgAdmin II:frmSQLOutput.LoadGrid: -2147217887 - Multiple-step OLE
DB operation generated errors. Check each OLE DB status value, if available.
No work was done."

when trying to do a basic query (select * from staff, or click the button
that has the same effect) on a table with the following definition:

CREATE TABLE "staff" (
"sid" int4 DEFAULT nextval('"staff_sid_seq"'::text) NOT NULL,
"lastname" varchar(128),
"firstname" varchar(128),
"preferred_contact_method" int4,
"initials" varchar(32),
"title" varchar(64),
"dob" date,
"emergency_contact_name" varchar(256),
"e_c_relationship" varchar(256),
"e_c_address_1" varchar(256),
"e_c_address_2" varchar(256),
"e_c_city" varchar(256),
"e_c_phone_day" varchar(256),
"e_c_phone_eve" varchar(256),
"e_c_phone_mob" varchar(256),
"e_c_email" varchar(256),
"sex" varchar(6),
"food_hygene_cert" bool,
"food_hygene_cert_expiry_date" date,
"first_aid_cert" bool,
"first_aid_cert_expiry_date" date,
"pgp_member" bool,
"pgp_member_from" date,
"smoker" bool,
"medical_notes" text,
"general_notes" text,
"tech_experience" int4,
"house_experience" int4,
"cafe_experience" int4,
"inactive" bool,
"e_c_county" varchar(128),
"e_c_post_code" varchar(64),
"e_c_country" varchar(128),
CONSTRAINT "staff_pkey" PRIMARY KEY ("sid")
) WITH OIDS;
REVOKE ALL ON "staff" FROM PUBLIC;
GRANT ALL ON "staff" TO "user1";
GRANT ALL ON "staff" TO "user2";

Here is the pgadmin (1.20) log at logging level "debug".

21/06/2002 22:42:48 - Counting Records...
21/06/2002 22:42:48 - SQL (PGP_Staff): SELECT count(*) AS count FROM "staff"
21/06/2002 22:42:48 - Done - 0.05 Secs.
21/06/2002 22:42:48 - Executing SQL Query...
21/06/2002 22:42:49 - SQL (PGP_Staff): SELECT * FROM "staff"
21/06/2002 22:42:49 - Loading Data...
21/06/2002 22:42:49 - Done - 0.5 Secs.
21/06/2002 22:42:49 - Error in pgAdmin
II:frmSQLOutput.LoadGrid: -2147217887 - Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if available. No work was
done.

There are 115 records in the "staff" table. After the error is reported a
display grid comes up, with 70-odd records displayed. I was able to view
this table before I had as many records. Running the query within psql on
the server causes no problems.

Any suggestions?
--
Thomas Sandford

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-06-22 21:29:10 Re: Rename column to number
Previous Message Lrat 2002-06-21 15:50:45 Rename column to number

Browse pgsql-hackers by date

  From Date Subject
Next Message Scott Marlowe 2002-06-21 22:07:38 Hash and bools
Previous Message Tom Lane 2002-06-21 21:16:50 Re: Reduce heap tuple header size

Browse pgsql-odbc by date

  From Date Subject
Next Message Juan Castillo 2002-06-22 00:01:31 Compiling Postgresq 7.2.1l with ODBC
Previous Message Julian Mehnle, Linksystem Muenchen 2002-06-21 15:24:56 Re: ODBC Driver 7.02.0001 (Win32) (Unicode mode): CRLF->LF works, LF->CRLF doesn't