Hi I have Created a program in visual studio and i have the oracle version 7.3 (I need to retrieve old Data) as my Database, but when i am trying to connect via my program, it returns error ORA-01017 Invalid username/password, but when i am entring those credential direcly on sql developer, i can connect successfully, why am i receiving this error? please someone help?
Here is my class:
using (var ghrconn = new OracleConnection(SRConn.CS7))
using (var orcmd = new OracleCommand("Select * from ca_table where userid = '111111'", ghrconn))
using (var orda = new OracleDataAdapter(orcmd))
orcmd.CommandType = CommandType.Text;
and this is my ConnectionString:
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 126.96.36.199)(PORT = 1500))) (CONNECT_DATA = (SID = HRMS)));User Id=userid;Password=userpw"
Thanks in Advance...