RE: [U2] OLEDB error

2009-02-28 Thread Debster
: Wednesday, February 18, 2009 4:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB error Insert to a view has several limitations: You cannot Insert multiple tables to a view with multiple tables. Only one table at a time. If a view is not showing all the fields and some

RE: [U2] OLEDB error

2009-02-28 Thread Symeon Breen
: RE: [U2] OLEDB error Well... After all the back and forth in attempting to transfer data back forth between a third party SQL Server based tool... IMHO -- Unidata XML is rudimentary at best. It is not exactly pretty, outbound is easy even if esthetically UGLY, is easily transmitted, read

RE: [U2] OLEDB error

2009-02-18 Thread Debra Fedchin
table. Is that correct ?? -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Debra Fedchin Sent: 17 February 2009 23:10 To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB error I know I know... Let me put

RE: [U2] OLEDB error

2009-02-18 Thread Garry Smith
Subject: RE: [U2] OLEDB error What is the actual sql command you are performing ? It is a bit confusing as the error talks about an insert but it is a select it is showing. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf

RE: [U2] OLEDB error

2009-02-17 Thread Debra Fedchin
to flat text files! It ain't rocket science! Horacio Pellegrino hpellegri...@optonline.net Sent by: owner-u2-us...@listserver.u2ug.org 02/12/2009 08:11 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject RE: [U2] OLEDB error Username has

RE: [U2] OLEDB error

2009-02-17 Thread Symeon Breen
February 2009 15:59 To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB error Yep All permission's are set to PUBLIC It is frustrating since most of the DOCS give examples of utilizing SQL statements as if you attempting to manipulate Unidata data within the Unidata server itself (duh -- now

RE: [U2] OLEDB error

2009-02-12 Thread Horacio Pellegrino
Username has permissions to create and insert granted? HP -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Debra Fedchin Sent: Wednesday, February 11, 2009 11:08 AM To: u2-users@listserver.u2ug.org Cc: