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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Schleis, David | 2005-09-13 13:19:56 | Re: problem |
Previous Message | Dave Page | 2005-09-13 08:02:47 | Re: Frontend/Backend protocol 3.0 update |