Username has permissions to create and insert granted? HP
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Debra Fedchin Sent: Wednesday, February 11, 2009 11:08 AM To: [email protected] Cc: [email protected]; '[email protected]' Subject: [U2] OLEDB error ok Can someone tell me why I got this error? Debug: OLEDB driver: Insert SQL='SELECT BIG_01_Invoice_Date, BIG_02_Invoice_Num, BIG_03_PO_Date, BIG_04_PO_Num, BIG_05_Rel_Num, BIG_07_Trans_Type, Benco_Host, CTT_01_CTT_Amt, DTM_01_Date_Qualifer, DTM_02_Date_Shipped, Date_Processed, EDI810_ID, Mailbox, N1_BT_01_Code, N1_BT_02_Name, N1_BT_03_Qualifier, N1_BT_04_ID, N3_BT_01_Address1, N3_BT_02_Address2, N4_BT_01_City, N4_BT_02_State, N4_BT_03_Zip, N4_BT_04_Country_Code, TDS_01_Amount, Trading_Partner, Vendor_Num FROM daf.EDI_INVOICE_HDR_NF_SUB WHERE (0=1)' Error: Couldn't insert row into table 'EDI_INVOICE_HDR_NF_SUB'. Error: Error 0x80004005: "[Ardent][UniData ODBC Driver][IBM][SQL Client][UNIDATA]Can not insert into view EDI_INVOICE_HDR_NF_SUB" Now -- this table was created, had SQL.CONVERT run against it, followed by going through VSG to create both Views and Subtables, all Privileges have been set to PUBLIC The error states that the table is a view when in fact it is a Subtable ================================================= This communication (including any attachments) is intended only for use by the addressee(s) named herein and may contain legally privileged or confidential information. If you are not the intended recipient or an authorized representative of the intended recipient on this communication, you are hereby notified that any dissemination or distribution of this communication (or attachments) is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and permanently delete the communication and any attachments from your system. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
