we followed your tips, it works now, thank you very much!<div><br></div><div>another &nbsp;question. &nbsp;we want to use copy into table to load txt file into monetdb.</div><div>if the txt file contains chinese character, we can&#39;t load it in. &nbsp;</div>
<div><br></div><div>we try to use squirrel to copy a table out &nbsp;to a txt file, if contains chinese character, the txt is utf8. &nbsp;we can copy this txt file into monetdb.</div><div><br></div><div>but if we use a notepad to build a new txt file, and save as to utf8 . &nbsp;load will be fail.&nbsp;</div>
<div><br></div><div>What&#39;s the problem? &nbsp;how can we build a utf8 txt file that has chinese characters can load it into monetdb?</div><div><br></div><div><br><br><div class="gmail_quote">2012/7/25 梁猛 <span dir="ltr">&lt;<a href="mailto:13802880779@139.com" target="_blank">13802880779@139.com</a>&gt;</span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>i modify the M5server.bat like this:</div>
<div>&nbsp;</div>
<div>&quot;%MONETDB%\bin\mserver5.exe&quot; --dbname=demo <font color="red">--set mapi_open=true </font>--set &quot;prefix=%MONETDB%&quot; --set &quot;exec_prefix=%MONETDB%&quot; %MONETDBFARM% %*</div>
<div></div>
<div><br><br></div><br>
<div></div>
<hr>

<div>
<div style="PADDING-BOTTOM:2px;PADDING-LEFT:0px;PADDING-RIGHT:0px;FONT-FAMILY:arial narrow;FONT-SIZE:12px;PADDING-TOP:2px">------------------&nbsp;原始邮件&nbsp;------------------ </div>
<div style="FONT-SIZE:12px;WORD-BREAK:break-all">
<div><b>发件人:</b>&nbsp;li, xiaohua<u></u>; </div>
<div><b>发送时间:</b>&nbsp;2012-07-25 16:36:05 </div>
<div><b>收件人:</b>&nbsp;monetdb-users<u></u>; </div>
<div><b>抄送:</b>&nbsp;(无); </div>
<div><b>主题:</b>&nbsp;[MonetDB-users] how to access remote server in windows </div></div><div><div class="h5">
<div>Hi all:
<div>&nbsp;&nbsp; &nbsp;we want to copy a text file into a remote server, we don&#39;t know how to set the mapi_open = yes &nbsp; on windows. &nbsp; &nbsp;we try add &nbsp; --set &quot;mapi_open= yes&quot; &nbsp;in the M5server.bat . but we don&#39;t know whether it take effect. how can we know?</div>

<div><br></div>
<div>&nbsp;&nbsp; when we use jdbc &nbsp;or odbc to access a remote monetdb database. &nbsp;we try to use</div>
<div><br></div>
<div>jdbc:monetdb://dvs001:5000/demo. &nbsp;or change the odbc host to an ip address: 192.168.1.100. &nbsp; &nbsp; &nbsp;we can&#39;t connect to the database. &nbsp; &nbsp;only we use localhost can we connect to the database.&nbsp;</div>
<div><br></div>
<div>&nbsp;&nbsp; &nbsp;does monetdb support remote access in windows? &nbsp;&nbsp;</div>
<div><br></div>
<div>lixiaohua</div>
<div>Shanghai,China</div>
<div><br></div>
<div><br></div></div></div></div></div><br>------------------------------------------------------------------------------<br>
Live Security Virtual Conference<br>
Exclusive live event will cover all the ways today&#39;s security and<br>
threat landscape has changed and how IT managers can respond. Discussions<br>
will include endpoint security, mobile security and the latest in malware<br>
threats. <a href="http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/" target="_blank">http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/</a><br>_______________________________________________<br>
MonetDB-users mailing list<br>
<a href="mailto:MonetDB-users@lists.sourceforge.net">MonetDB-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/monetdb-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/monetdb-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>上海云数信息科技有限公司<div><a href="http://www.cloudybi.com" target="_blank">http://www.cloudybi.com</a></div><div>联系人：李晓华</div><div>职务：总经理</div><div>手机：18616507502</div>
<br>
</div>