Обсуждение: EDB database link to Oracle

Поиск
Список
Период
Сортировка

EDB database link to Oracle

От
"Travis Smith"
Дата:

When using a database link in Postgres Plus AS 8.3 to an Oracle instance I receive…

 

 

SQL> create database link ezdev connect to pguser identified by pguser

  2  using oci '//devdb:1521/ezdev'

  3  ;

 

Database Link created.

 

SQL> select * from ezorder@ezdev;

ERROR near line 1:

unable to load OCI library: Access is denied.

 

 

Im on windows the enterprisedb user is an Administrator.  What am I missing?  Thanks

 

 

-TaS



The information in this email or in any file attached hereto is intended only for the personal and confidential use of the individual or entity to which it is addressed and may contain information that is proprietary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email transmission cannot be guaranteed to be secure or error-free. P6070214

Re: EDB database link to Oracle

От
"Joshua D. Drake"
Дата:
Travis Smith wrote:
> When using a database link in Postgres Plus AS 8.3 to an Oracle instance
> I receive…

You should contact EnterpriseDB for support with their products.

Joshua D. Drake

Re: EDB database link to Oracle

От
"Travis Smith"
Дата:
Thanks for the head up.  I was just informed.



-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Tuesday, May 13, 2008 8:56 AM
To: Travis Smith
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] EDB database link to Oracle

Travis Smith wrote:
> When using a database link in Postgres Plus AS 8.3 to an Oracle
instance
> I receive...

You should contact EnterpriseDB for support with their products.

Joshua D. Drake

_______________________________________________________

The  information in this email or in any file attached
hereto is intended only for the personal and confiden-
tial  use  of  the individual or entity to which it is
addressed and may contain information that is  propri-
etary  and  confidential.  If you are not the intended
recipient of this message you are hereby notified that
any  review, dissemination, distribution or copying of
this message is strictly prohibited.  This  communica-
tion  is  for information purposes only and should not
be regarded as an offer to sell or as  a  solicitation
of an offer to buy any financial product. Email trans-
mission cannot be guaranteed to be  secure  or  error-
free. P6070214