"Multiple-step OLE DB operation generated errors" in pgAdmin II:frmSQLOutput.LoadGrid
От | Thomas Sandford |
---|---|
Тема | "Multiple-step OLE DB operation generated errors" in pgAdmin II:frmSQLOutput.LoadGrid |
Дата | |
Msg-id | 01a701c2196e$12266bc0$0300000a@paradise обсуждение исходный текст |
Ответ на | pgAdmin users upgrading to PostgreSQL 7.2 (Dave Page <dpage@vale-housing.co.uk>) |
Список | pgadmin-support |
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
В списке pgadmin-support по дате отправления: