[unixODBC-support] WORKAROUND SOLUTION INFO & PLEASE PROVIDE A 32 BIT CONFIGURE OPTION

Ilming Elvira (Semizen) elvira.ilming at niedermeyer.at
Thu Sep 15 17:45:13 BST 2005


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 unixODBC AS 32 BIT VERSION (The Oracle hsodbc part is 32bits only in Oracle 10g).

PLEASE PROVIDE A 32 BIT OPTION IN THE configure SCRIPT IN FUTURE VERSIONS OF unixODBC. THANK YOU!

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 at test;
select * from dual at 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







More information about the unixODBC-support mailing list