Skip site navigation (1) Skip section navigation (2)

WORKAROUND SOLUTION INFO & PLEASE PROVIDE A 32 BIT CONFIGURE OPTION

From: "Ilming Elvira (Semizen)" <elvira(dot)ilming(at)niedermeyer(dot)at>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: "Weiss Matthias (Semizen)" <matthias(dot)weiss(at)niedermeyer(dot)at>,"Fleischhacker Erwin (Semizen)" <erwin(dot)fleischhacker(at)niedermeyer(dot)at>
Subject: WORKAROUND SOLUTION INFO & PLEASE PROVIDE A 32 BIT CONFIGURE OPTION
Date: 2005-09-15 16:48:45
Message-ID: 4F84F52F97689940841C4177DCA31E799479EA@000ns030.niedermeyer.private (view raw or flat)
Thread:
Lists: 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(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


pgsql-odbc by date

Next:From: Robin WeberDate: 2005-09-15 17:53:23
Subject: Re: ODBC Driver Failure- MS Access- Large record volume
Previous:From: Dave PageDate: 2005-09-15 13:37:33
Subject: Re: ODBC Driver on Windows 64 bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group