[unixODBC-support] (no subject)

David_Winkler/LeonhardLang%LEONHARDLANG at leonhardlang.at David_Winkler/LeonhardLang%LEONHARDLANG at leonhardlang.at
Tue Jul 27 10:22:23 BST 2004






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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20040727/4ac78813/attachment.html>


More information about the unixODBC-support mailing list