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@000ns112 bin]# ./odbcinst --version
unixODBC 2.2.11
http://www.postgresql.org
psqlodbc-08.00.0102 (ODBC DRIVER)
==========
isql works
==========
[oracle@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@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@crm_odbc;
select * from customers@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
