oracle db connection
Posted: Mon May 13, 2013 7:31 am
i m trying to connect to oracle db connection, and in tnsnames.ora --->
life151 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.151)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
like this is there and through command prompt i am able to connect but using this tool m not able to connect and
Provider=MSDAORA;Data Source=life151;User ID=xxx;Password=xxx,
but when i try to test connection, it is giving the error like :ORA:12546: TNS permission denied...
please help in this
life151 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.151)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
like this is there and through command prompt i am able to connect but using this tool m not able to connect and
Provider=MSDAORA;Data Source=life151;User ID=xxx;Password=xxx,
but when i try to test connection, it is giving the error like :ORA:12546: TNS permission denied...
please help in this