[Monetdb-developers] regarding monetdb data type
Hi, i installed MonetDB server and client. it works fine with console to create table and insert data. but if insert data larger than 512 byte, i can not get the whole data back to excel. can someone tell me what are the things that may be going wrong. thank u.
Tomas, we've recently received a similar report by Xiao Lei; cf., https://sourceforge.net/mailarchive/forum.php?thread_name=m2p30b36e111004071938o227e51d4x7d87612a6224ea5%40mail.gmail.com&forum_name=monetdb-developers Since you mention excel, may I assume that you are running MonetDB (which version?) on Windows and are using ODBC to let Excel communicate with MonetDB? I assume that you might be hitting some yet undetected bug in MonetDB and/or its Windows ODBC driver. Xiao Lei, Tomas, could either of you please file a bug report with the MonetDB bug tracker on SF (https://sourceforge.net/tracker/?atid=482468&group_id=56967&func=browse), preferably including detailed instructions how to reproduce your problem. We'll then investigate and try to fix the problem. Thanks in advance, Stefan On Mon, Apr 12, 2010 at 05:21:41PM +0800, Tomas Lopez wrote:
Hi,
i installed MonetDB server and client. it works fine with console to create table and insert data. but if insert data larger than 512 byte, i can not get the whole data back to excel. can someone tell me what are the things that may be going wrong. thank u.
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |
Hi Stefan,
Thanks for your reply. Yes, I'm running MonetDb on Windows with ODBC. Since
I can not get data from varchar or var, I'm trying to get BLOB data from
ODBC now. It works fine when I write into the database, but I got this error
when I try to read it,
ERROR [07006] [MonetDB][ODBC Driver 1.0]Restricted data type attribute
violation
Table struct:
create table testtbl (id int,dt blob);
Can you help me with that? thx a lot.
2010/4/12 Stefan Manegold
Tomas,
we've recently received a similar report by Xiao Lei; cf.,
Since you mention excel, may I assume that you are running MonetDB (which version?) on Windows and are using ODBC to let Excel communicate with MonetDB?
I assume that you might be hitting some yet undetected bug in MonetDB and/or its Windows ODBC driver.
Xiao Lei, Tomas,
could either of you please file a bug report with the MonetDB bug tracker on SF ( https://sourceforge.net/tracker/?atid=482468&group_id=56967&func=browse), preferably including detailed instructions how to reproduce your problem.
We'll then investigate and try to fix the problem.
Thanks in advance,
Stefan
On Mon, Apr 12, 2010 at 05:21:41PM +0800, Tomas Lopez wrote:
Hi,
i installed MonetDB server and client. it works fine with console to create table and insert data. but if insert data larger than 512 byte, i can not get the whole data back to excel. can someone tell me what are the things that may be going wrong. thank u.
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |
-- Best Regards, Xiao Lei
participants (3)
-
Stefan Manegold -
Tomas Lopez -
Xiao Lei