Hey i am asking this question again even after going through som many resources related to it i am not finding any solution.
I have a connection string which looks something like this
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL = TCPS)(HOST =XXX)(PORT = 1523))(CONNECT_DATA=(SERVER = dedicated)(SERVICE_NAME=XXX))(SECURITY=(SSL_SERVER_CERT_DN= CN=XXX)(MY_WALLET_DIRECTORY=C:\Wallet)));User Id=XXX;PASSWORD=XXX;
I configured this in the web.config file as
<connectionStrings>
<add name="ConnectionString" connectionString="{connection string encrypted form}" providerName="Oracle.ManagedDataAccess.Client" />
</connectionStrings>
My application is a ASP.NET application
When i try to connect with this i am getting
System.Exception: Database Connectivity Exception, GetMaxDatabaseConnectivityTries Tries of 10 ended, Exception : Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12545: Network Transport: Unable to resolve connect hostname --->
Diffrent methods i tried
1.I configured the same TNS in my tnsnames.ora and tried to connect using toad. I was able to connect. 2. I tried to ping the host name, I got response from the host. 3. Preveious to this the connection string which was working looked something like this
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL = TCPS)(HOST =XXX)(PORT = 1523))(CONNECT_DATA=(SERVER = dedicated)(SERVICE_NAME=XXX));User Id=XXX;PASSWORD=XXX;
I am assuming the problem occured solely because of addition of the new security parameters.
Any help is deeply appreciated, Thanks in advance.
User contributions licensed under CC BY-SA 3.0