from http://sourceforge.net/mailarchive/message.php?msg_id=29589054:On Wed, Jul 25, 2012 at 04:35:01PM +0200, Sjoerd Mullender wrote:
> On 2012-07-25 15:32, li, xiaohua wrote:
> > Hi all:
> > we want to copy a txt file into a remote monetdb (windows).
> > if we copy into local monetdb via ipaddress, it's OK.
> > but if we copy the same txt file into a remote monetdb, it can't.
> >
> > Error: could not open file 'd:\\share\\book1.csv': Operation not permitted
> > SQLState: 22000
> > ErrorCode: 0
> >
> > what's the problem? is it a bug? or something we don't know?
> >
> >
> > lixiaohua
> > Shanghai,China
>
> Assuming you use something like
> COPY INTO t FROM 'd:\\share\\book1.csv' ...
> then the mserver has to be able to read the file using that path. If
> you're logged into the mserver with an account other than monetdb, this
> will not be allowed for security reasons. If you do this remotely (i.e.
> the server runs on a different system than mclient), the server will try
> to read the file on it's system, not mclient's system.
>
> If you want a remote mserver to read a file on the same host as where
> mclient is running, you have to send the file through mclient (which is
> a bit tricky on Windows).
>
> Start by looking at
> <http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/LoadingData>
> and the manual page at
> <http://www.monetdb.org/Documentation/mclient-man-page> on how this can
> be done. You'll need to use the mclient.bat script instead of the
> mclient.exe binary and run all of this from a cmd window. The
> description is written with Linux in mind, but something very similar
> should also work on Windows.
>
> You may have to specify a -E option (see the manual).
>
> --
> Sjoerd Mullender
"
I have find the solution
you must do COPY INTO from PROMPT OF DOS like this:
C:\Program Files\MonetDB\MonetDB5>
mclient -d demo -s " COPY INTO LINEORDER FROM STDIN USING DELIMITERS
'|','\n'" - < G:\BDC\DATA\LINEORDER.tbl
LINEORDER IS the table in database and LINEORER.tbl is the text file that
contain data to load, and demo is the name of database
"
Stefan
| Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
| http://CWI.nl/~manegold/ | Science Park 123 (L321) |
| Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users