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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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