I have a question about accessing MonetDB via Oracle using ODBC.
I have oracle on machine1 (ubuntu 64bit) and MonetDB on machine2(ubuntu 64bit)
I installed Monetdb odbc driver using
apt-get install libmonetdb-client-odbc
I have done all the needed configurations for the listner, tnsnames, sqlnet, initservice.ora and I used UnixODBC.
After creating the database link, I get this error when I try to connect MonetDB:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][MonetDB][ODBC Driver 11.11.11]Client unable to establish connection
{08001}
ORA-02063: preceding 2 lines from MONETDB
I don't know if the use of (64bit) needs some special configurations?? or its du to something else.
So I need your help to figure out what is the problem....
Best regards,
Baraa