Hello Sjoerd,I created a bug report ( bug 3392).I hope you can help me solve this problem. Do I can post a part of the log file here or I should better wait the answer for the bug report. P.S: setting the ODBCDEBUG variable has not worked for me to create the ODBC log file so I created it using unixODBC allow trace option, I hope this can give the needed info. Thanks againBaraa Date: Sat, 2 Nov 2013 09:15:11 +0100 From: sjoerd@monetdb.org To: users-list@monetdb.org Subject: Re: Monetdb ODBC datatype conversion problem Yuu can try to create and look at debug output from the ODBC driver. See bug 2910, comment 1 for instructions on how to do that (http://bugs.monetdb.org/show_bug.cgi?id=2910#comment_text_1). If you can't figure out what it means, you can create a bug report and attach the log. On 2013-11-02 00:29, baraa Mohamad wrote:
Dear MonetDB users,
I have created a database link from oracle to monetdb using Monetdb ODBC driver, the link works fine but i have a strange results Emoji
I have the following configurations: host1: Oracle (ubuntu 64bit) host2: MonetDB (ubntu 64bit) ODBC driver: MonetDB odbc (64bit) using unixODBC driver manager
on monetdb i have the following table: emp (id *integer *, name varchar);
test query: select id from emp where id<20;
when I execute this query directly on montdb I get the following results (IDs from 1 to 19) ID 1 2 3 . . 19
BUT when I execute this query from oracle using dblink
select "id" from "emp"@monetdb where "id"<20 ;
I GET THE FOLLOWING RESULTS:
ID -------- *1* *8589934592* *2* *1.2885E+10* *3* *1.7180E+10* *4* *2.1475E+10* *5* *2.5770E+10* *6* *3.0065E+10* *7* *3.4360E+10* *8* *3.8655E+10* *9* *4.2950E+10* *10*
I cannot figure out the cause of the problem and how I can solve it (it seems a problem related to datatype conversion using ODBC) *Could you please tell me what I should do....*
Best regards, Baraa
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list