Asp.Net - Oracle Connection failed
-
Hi, I am using oracle and c#.net. In my application, i need to populate a dropdownlist from one oracle db of a particular server/port/schema and populate another dropdownlist from another oracle db from another server/port. Both the connections were success while connecting using oracle sql developer tool but in my application, i could not load the second control. Invalid username/password. logon failed error comes for the same credentials. I am new to oracle. Please help me where i have to correct. Thanks in advance. Thanks, Lalitha
-
Hi, I am using oracle and c#.net. In my application, i need to populate a dropdownlist from one oracle db of a particular server/port/schema and populate another dropdownlist from another oracle db from another server/port. Both the connections were success while connecting using oracle sql developer tool but in my application, i could not load the second control. Invalid username/password. logon failed error comes for the same credentials. I am new to oracle. Please help me where i have to correct. Thanks in advance. Thanks, Lalitha
That means the supplied credentials are wrong (for the second case). Provide correct credentials and it should work. Check Checking Connection to Oracle Database for testing the connectivity. In case , the credentials are correct, then may be the connection path is wrong e.g. in
OracleConnection connection = new OracleConnection(@connectionPath);
check the value for @connectionPath e.g.
string connectionPath = "Data Source=orcl;User Id=scott;Password=tiger;Persist Security Info=False";
Hope this will help. [^]
Niladri Biswas (Code Project MVP 2012)