we also found that, seems bom is the reason. thank you! how long have you use MonetDB, we want to use it in productvity environment, how do you think? ---------- Forwarded message ---------- From: 梁猛 <13802880779@139.com> Date: 2012/7/26 Subject: Re: [MonetDB-users] how to access remote server in windows To: Communication channel for MonetDB users < monetdb-users@lists.sourceforge.net> transform the gbk text file into utf-8, i will work! use ultraedit or other text editor, save as, and "utf no bom" ------------------------------ ------------------ 原始邮件 ------------------ *发件人:* li, xiaohua**; *发送时间:* 2012-07-25 17:49:31 *收件人:* Communication channel for MonetDB users**; *抄送:* (无); *主题:* Re: [MonetDB-users] how to access remote server in windows we followed your tips, it works now, thank you very much! another question. we want to use copy into table to load txt file into monetdb. if the txt file contains chinese character, we can't load it in. we try to use squirrel to copy a table out to a txt file, if contains chinese character, the txt is utf8. we can copy this txt file into monetdb. but if we use a notepad to build a new txt file, and save as to utf8 . load will be fail. What's the problem? how can we build a utf8 txt file that has chinese characters can load it into monetdb? 2012/7/25 梁猛 <13802880779@139.com>
i modify the M5server.bat like this:
"%MONETDB%\bin\mserver5.exe" --dbname=demo --set mapi_open=true --set "prefix=%MONETDB%" --set "exec_prefix=%MONETDB%" %MONETDBFARM% %*
------------------------------ ------------------ 原始邮件 ------------------ *发件人:* li, xiaohua**; *发送时间:* 2012-07-25 16:36:05 *收件人:* monetdb-users**; *抄送:* (无); *主题:* [MonetDB-users] how to access remote server in windows Hi all: we want to copy a text file into a remote server, we don't know how to set the mapi_open = yes on windows. we try add --set "mapi_open= yes" in the M5server.bat . but we don't know whether it take effect. how can we know?
when we use jdbc or odbc to access a remote monetdb database. we try to use
jdbc:monetdb://dvs001:5000/demo. or change the odbc host to an ip address: 192.168.1.100. we can't connect to the database. only we use localhost can we connect to the database.
does monetdb support remote access in windows?
lixiaohua Shanghai,China
------------------------------------------------------------------------------ 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://www.cloudybi.com 联系人:李晓华 职务:总经理 手机:18616507502 ------------------------------------------------------------------------------ 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://www.cloudybi.com 联系人:李晓华 职务:总经理 手机:18616507502