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

Connecting from ORACLE to PostgreSQL via ODBC does not work: "driver not licensed"

From: "Ilming Elvira (Semizen)" <elvira(dot)ilming(at)niedermeyer(dot)at>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Connecting from ORACLE to PostgreSQL via ODBC does not work: "driver not licensed"
Date: 2005-09-13 13:05:36
Message-ID: 4F84F52F97689940841C4177DCA31E799479D5@000ns030.niedermeyer.private (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello from Vienna/Austria,

I'm new to this list and I could not find an answer to my question in the archive.
This is why I would appreciate any kind of hints from your side!

For example:
DO YOU KNOW ANYONE WHO HAS ALREADY SUCCEEDED TO CONNECT FROM ORACLE DATABASE VIA ODBC TO POSTGRESQL?

ERROR MESSAGE:
[Generic Connectivity Using ODBC][A07A] 'GENERIC_ODBC_FOR_HS' driver is not
licensed

Here comes the details step by step:
==========================================
Connecting from ORACLE to PostgreSQL via ODBC does not work: "driver not licensed" 
==========================================

The following ODBC Driver is installed with the postgreSQL Driver.

http://www.unixodbc.org/
[root(at)000ns112 bin]# ./odbcinst --version
unixODBC 2.2.11

http://www.postgresql.org
psqlodbc-08.00.0102 (ODBC DRIVER)

==========
isql works
==========

[oracle(at)000ns112 admin]$ isql -v crm_prod crm '+++++++++++'
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select cus_user from crm.customers limit 10
+-----------+
| cus_user  |
+-----------+
| tradnetter|
| tradnetter|
| tradnetter|
| tradnetter|
| tradnetter|
| tradnetter|
| tradnetter|
| tradnetter|
| tradnetter|
| tradnetter|
+-----------+
SQLRowCount returns 10
10 rows fetched

====================
TNSPING does work OK
====================
[oracle(at)000ns112 admin]$ tnsping crm
TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 08-SEP-2005 
16:37:55
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
/oracle/OraHome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS = (PROTO = TCP)(HOST = 
000ns112.niedermeyer.private)(PORT = 1521)) (CONNECT_DATA= (SID = crm_prod)) 
(HS = OK))
OK (0 msec) 

=========================
Connect from ORACLE FAILS
=========================

Connected to:
Oracle Database 10g Release 10.1.0.3.0 - 64bit Production
SQL> select * from customers(at)crm_odbc;
select * from customers(at)crm_odbc
*
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 CRM_ODBC 
****************************************************************************

Any kind of suggestions or ideas warmly welcome!

Have a great day,

Elvira

www.ilming.com


pgsql-odbc by date

Next:From: Schleis, DavidDate: 2005-09-13 13:19:56
Subject: Re: problem
Previous:From: Dave PageDate: 2005-09-13 08:02:47
Subject: Re: Frontend/Backend protocol 3.0 update

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