Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error testing UDL file, no error in Oracle Net Manager or SQL developer

623993Feb 19 2008
Hi

When programming some code I am in need of debugging with a connection to a remote connection. To connect to the server I use VPN to connect.
I'm trying to test a connection to an Oracle database using an UDL file on my computer, but the connection fails with the following message: "Test connection failed because of an error in initializing provider. ORA-12546: TNS:Permission denied".
I've found a lot of listings about this error message on the web but none that covers my issue.

When I use the Oracle Net Manager to test the connection, I see all my listings in the tnsnames.ora file and when i test the connection here it works fine. I have also tested the connection to the database in Oracle SQL developer, and I'm able to connect to the database here using the same TNSNAMES file as on the server.

I have remote access to an application server that connects to the database and I use the following connectionstring here, and it works from this server :
Provider=OraOLEDB.Oracle.1;Password=******;Persist Security Info=True;User ID=*****;Data Source=BWTEST.customer.com
But when I try to use the same connection string using VPN from my computer it fails and displays the mentioned ORA-12546 message.


Listing in the tnsnames.ora :
BWTEST.customer.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = ares.customer.com)
(PORT = 1821)
)
)
(CONNECT_DATA =
(SID = FASC)
)
)

What am I doing wrong? It should be possible to connect to test the connection when I am able to use the SQL developer on the same connection.

Other details:
Client computer: Win XP sp2
VPN software: Forte eVPN (Conitivity)
Oracle Client : 10.1.0 (installed all options under client installer)

Please tell if you're in need of more information.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2008
Added on Feb 19 2008
0 comments
746 views