Skip site navigation (1) Skip section navigation (2)

"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 (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-odbc by date

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

pgadmin-support by date

Next:From: Dave PageDate: 2002-06-22 21:29:10
Subject: Re: Rename column to number
Previous:From: LratDate: 2002-06-21 15:50:45
Subject: Rename column to number

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group