WORKAROUND SOLUTION INFO & PLEASE PROVIDE A 32 BIT CONFIGURE OPTION - Mailing list pgsql-odbc

From Ilming Elvira (Semizen)
Subject WORKAROUND SOLUTION INFO & PLEASE PROVIDE A 32 BIT CONFIGURE OPTION
Date
Msg-id 4F84F52F97689940841C4177DCA31E799479EA@000ns030.niedermeyer.private
Whole thread Raw
List pgsql-odbc
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


pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: ODBC Driver on Windows 64 bit
Next
From: Robin Weber
Date:
Subject: Re: ODBC Driver Failure- MS Access- Large record volume