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
<Stefan.Manegold@cwi.nl>
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 |
--
Best Regards,
Xiao Lei