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@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

Contact easysoft support and they will get you working.
Email them on support@easysoft.com

Cheers,
Stuart.

On Tue, 27 Jul 2004 11:25:58 +0200, David Winkler wrote:

> 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"
>