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

EDB database link to Oracle

From: "Travis Smith" <tsmith(at)optionshouse(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: EDB database link to Oracle
Date: 2008-05-13 13:45:19
Message-ID: 347D0FD56F1C5745B0659D8E27B1BC30023FA1EB@epi-mail1.optionshouse.net (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)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 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

Responses

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2008-05-13 13:56:28
Subject: Re: EDB database link to Oracle
Previous:From: Scott MarloweDate: 2008-05-13 08:48:32
Subject: Re: how to get a number of seconds in some interval ?

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