-
Error ORA-02019 if using an Excel vba Application
Hi,
I'm using a database link in a synonym to a remote DB with tables/views in a schema of another user.
( Oracle 11g )
DB-Link:
create database link ALUPLINK
connect to DBL_User
using 'ALUDB';
Synonym :
create or replace synonym AWS_VW_WBESTAND
for AWS._VW_WBESTAND@ALUPLINK;
SQL-Stmt:
select * from AWS_VW_WBESTAND ;
DB-Link and synonym are private, user is Abarth.
If user User Abarth connects, using SQL/Plus or PL/SQL-Developer the Select works fine. Everything OK.
But if I use an Excel VBA Application( 2003, MS ADO 2.1 ) with the same user, password and DB I get the Error : ORA-02019: connection description for remote database not found
If I change the user, both( SQL-Plus and Excel ) works. In both Cases db-link and synonym are private, both users only got granted SELECT onto the View AWS_VW_WBESTAND.
I cannot find differences between the granted rights.
So what is the difference between using link and synonym interactive and using them out of an Excel-vba-App ? Special rights ?
Thanks.
Dirk
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|