Error in SSIS Connection says (Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener)
-
Hi all, I have an SSIS Package, I am using the Oracle Database table as Datasource in my package, when I am trying to Edit and Test the Connection by putting the credentials its giving me the following error.
Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener
I did set the Oracle_Home to the right directory, still I am getting the problem. Now I set the TNS_ADMIN also with the network folder still getting the error. Can anybody help me in resolving this issue, any help is going to be greatly helpful, thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
-
Hi all, I have an SSIS Package, I am using the Oracle Database table as Datasource in my package, when I am trying to Edit and Test the Connection by putting the credentials its giving me the following error.
Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener
I did set the Oracle_Home to the right directory, still I am getting the problem. Now I set the TNS_ADMIN also with the network folder still getting the error. Can anybody help me in resolving this issue, any help is going to be greatly helpful, thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
looks like the network connection isn't ok - I would first check if the connection to the server is ok by using tnsping: https://docs.oracle.com/cd/E11882_01/network.112/e41945/connect.htm#NETAG357 or try to connect with orcale sql developper