Hi,
as ORACLE does not support ODBC on Linux x86 - 64 bit
(ERROR [A07A] 'GENERIC_ODBC_FOR_HS' driver is not licensed)
a possible WORKAROUND IS TO COMPILE the postgreSQL ODBC AS 32 BIT VERSION (In Oracle 10g the hsodbc part is 32bits only
).
PLEASE PROVIDE A 32 BIT OPTION IN THE configure SCRIPT IN FUTURE VERSIONS OF unixODBC.
Thank you and have a great day,
Elvira
=======================================================================
This is what we have done manually.
=======================================================================
1) Prepare Flags for compilation
File libtool: change entry "-shared" to "-shared -m32"; two occurences
=======================================================================
2) Set Flags & configure
CFLAGS=-m32 LDFLAGS=-m32 CXXFLAGS=-m32 ./configure
make
make install
=======================================================================
IF YOU ARE INTERESTED IN MORE INFO OF THE TOPIC:
Connect from ORACLE 10.1.0.3 to PostgreSQL 8.00.0102, 32bit WORKAROUND
I COULD SEND YOU DETAILED SETUP INSTRUCTIONS
=======================================================================
metalink.oracle.com
ORIGINAL TAR: 15551084.6
Server: Linux x86-64bit RedHat Enterprise
Oracle: Version 10.1.0.3.0
unixODBC: Version 2.2.11
PostgreSQL ODBC: Version 08.00.0102
======
ERROR:
======
[A07A] 'GENERIC_ODBC_FOR_HS' driver is not licensed
=======
REASON:
=======
Oracle supports only HS ODBC for 32bit
There is no licence for 64 bit
=========
SOLUTION:
=========
Compile unixODBC and PostgreSQL ODBC Driver as 32bit
Put license binary brand.bin manually to $ORACLE_HOME/hs/bin/
========
DETAILS:
========
SQL> select * from dual@test;
select * from dual@test
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][A07A] 'GENERIC_ODBC_FOR_HS' driver is not
licensed
ORA-02063: preceding 2 lines from TEST
