Error testing UDL file, no error in Oracle Net Manager or SQL developer
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.