Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> unixODBC Easysoft ODBC conntects Oracle DB

unixODBC Easysoft ODBC conntects Oracle DB

From: David Winkler <david.winkler_at_leonhardlang.at>
Date: Tue, 27 Jul 2004 11:25:58 +0200
Message-ID: <6c6cg0tiq22e9tmkn8vavirs6728aj9pru@4ax.com>


Hi,

I'm trying to get connected from a linux client to a Oracle-DB (9.2i) using the Easysoft Oracle-ODBC and unixODBC, but no chance :-( I went throug every manual regarding the installation, but every time, on diffrent machines, i'm getting the same error: "[ISQL]ERROR: Could not SQLConnect"

So, what did I do (the full last week):

oracle-server:
Oracle 9.2i on Suse Linux 8 (United Linux)

ODBC-clientserver
RedHat9

oracle-instantclient
(oracle-instantclient-basic-10.1.0.2-1.i386.rpm and oracle-instantclient-sqlplus-10.1.0.2-1.i386.rpm)

easysoft ODBC-Oracle Client (+unixODBC)
(odbc-oracle-2.0.0-linux-glibc.tar)

Installation:

<snip>
rpm -Uvh oracle-instantclient-basic-10.1.0.2-1.i386.rpm rpm -Uvh oracle-instantclient-sqlplus-10.1.0.2-1.i386.rpm vim /etc/tnsnames.ora

---
ORCL = 
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server.leonhardlang.at)(PORT =
1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
---

# sqlplus user/password_at_orcl
# SQL>select COLUMN from TABLE
<snap> Works fine!!! Installation Easysoft oracle-ODBC: unpack tar-file ./install (everything defaul, as descripted in "INSTALLATION - Installing the Easysoft ODBC-Oracle Driver) Fetching Trial-Licence from the licence-deamon create DSN Databasename = orcl username Passwort installation complete
# cat /etc/odbc.ini
<snip> [ORACLE] Driver = ORACLE Database = orcl User = xxx Password = xxx METADATA_ID = 0 ENABLE_USER_CATALOG = 1 ENABLE_SYNONYMS = 1 <snap>
# cat /etc/odbcinst.ini
<snip> [ORACLE] Description = Easysoft ODBC Oracle Driver Driver = /usr/local/easysoft/oracle/libesoracle.so Setup = /usr/local/easysoft/oracle/libesoraclesetup.so FileUsage = 1 <snap>
# EASYSOFT=/usr/local/easysoft/
# LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/10.1.0.2/client
# LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$EASYSOFT/lib
# LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$EASYSOFT/oracle
# LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/easysoft/unixODBC/lib/
# export LD_LIBRARY_PATH
testing with isql-client (unixODBC)
# sql -v ORACLE
[ISQL]ERROR: Could not SQLConnect No further logfiles (TRACE=on has no use) same thing tested on another machine (Fedora Core2) any suggestions? Dave
Received on Tue Jul 27 2004 - 04:25:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US