Hi
Perhaps you stumbled upon the follow issue in the clients/ODBC/driver/SQLconnect.c
/* connect to a server on host via port */ /* FIXME: use dbname/catalog from ODBC connect string/options here */ mid = mapi_connect(host, port, uid, pwd, "sql", catalog); if (mid == NULL || mapi_error(mid)) { /* Client unable to establish connection */ addDbcError(dbc, "08001", NULL, 0);
i.e. an open-end in the implementation.
Martin
On 10/26/13 10:00 AM, baraa Mohamad wrote:
Hi lefteris, How I can test that?
Baraa
Date: Sat, 26 Oct 2013 09:48:44 +0200 Subject: Re: Accessing MonetDB form Oracle DB From: lsidir@gmail.com To: users-list@monetdb.org
Hi Baraa,
are you able to connect to monetdb with ODBC but without using oracle? at this point, for me at least, it is unclear if the problem is in monetdb connectivity or in oracle.
lefteris
On Sat, Oct 26, 2013 at 9:33 AM, baraa Mohamad bem85@hotmail.com wrote:
Here are more informations, I really need a help please,
I have oracle 11g installed on machine1 (ubuntu 64bit) , and I have MonetDB installed on machine2 (ubuntu 64bit, ip= 192.168.56.101)
I need to access MonetDB database from oracle.
I followed the configurations steps but I get always the following error:
select "id" from "test"@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 installed unixODBC on the machine1 and I used MonetDB ODBC driver which generates the following odbc.ini file
[monetdb]
Description = MonetDB
Driver = /usr/lib64/libMonetODBC.so
Host = 192.168.56.101
Port = 50000
Database = demo
User = monetdb
Password = monetdb
Debug =
Here are my configurations:
tnsnames.ora:
monetdb =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST =localhost)
(PORT =1521)
)
(CONNECT_DATA =
(SID=monetdb))
(HS = OK))
Listner.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=monetdb)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
(PROGRAM=dg4odbc)
(ENVS=LD_LIBRARY_PATH=/usr/lib64:$ORACLE_HOME/lib)
)
)
In $ORACLE_HOME/hs/admin I created the file initmonetdb.ora
HS_FDS_CONNECT_INFO=monetdb
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_SUPPORT_STATISTICS=FALSE
HS_FDS_SHAREABLE_NAME=/usr/lib64/libodbc.so
HS_LANGUAGE=american_america.we8iso8859p1
set ODBCINI=/etc/odbc.ini
when I do lsnrctl start i get the following
Log messages written to /u01/app/oracle/diag/tnslsnr/OracleUbuntu/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 26-OCT-2013 01:32:37
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/OracleUbuntu/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "monetdb" has 1 instance(s).
Instance "monetdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
any ideas why I get this error??
Regards
Baraa
From: bem85@hotmail.com To: users-list@monetdb.org Subject: Accessing MonetDB form Oracle DB Date: Fri, 25 Oct 2013 11:13:37 +0000
Dear MonetDB users,
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
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list