pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedEDB database link to Oracle
3+ messages / 2 participants
[nested] [flat]
* EDB database link to Oracle
@ 2008-05-13 13:45 Travis Smith <tsmith@optionshouse.com>
2008-05-13 13:56 ` Re: EDB database link to Oracle Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 3+ messages in thread
From: Travis Smith @ 2008-05-13 13:45 UTC (permalink / raw)
To: 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@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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: EDB database link to Oracle
2008-05-13 13:45 EDB database link to Oracle Travis Smith <tsmith@optionshouse.com>
@ 2008-05-13 13:56 ` Joshua D. Drake <jd@commandprompt.com>
2008-05-13 14:04 ` Re: EDB database link to Oracle Travis Smith <tsmith@optionshouse.com>
0 siblings, 1 reply; 3+ messages in thread
From: Joshua D. Drake @ 2008-05-13 13:56 UTC (permalink / raw)
To: Travis Smith <tsmith@optionshouse.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: EDB database link to Oracle
2008-05-13 13:45 EDB database link to Oracle Travis Smith <tsmith@optionshouse.com>
2008-05-13 13:56 ` Re: EDB database link to Oracle Joshua D. Drake <jd@commandprompt.com>
@ 2008-05-13 14:04 ` Travis Smith <tsmith@optionshouse.com>
0 siblings, 0 replies; 3+ messages in thread
From: Travis Smith @ 2008-05-13 14:04 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-05-13 14:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-13 13:45 EDB database link to Oracle Travis Smith <tsmith@optionshouse.com>
2008-05-13 13:56 ` Joshua D. Drake <jd@commandprompt.com>
2008-05-13 14:04 ` Travis Smith <tsmith@optionshouse.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox