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
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 |
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 |
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 |