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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robin Weber | 2005-09-15 17:53:23 | Re: ODBC Driver Failure- MS Access- Large record volume |
Previous Message | Dave Page | 2005-09-15 13:37:33 | Re: ODBC Driver on Windows 64 bit |