1 Reply Latest reply on Jun 8, 2018 9:08 AM by Hendrik Schmidt

    ORA-01017 Error on Connecting From Visual Studio to Oracle

    Zackelberry

      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;

                          ghrconn.Open();

                          orda.Fill(ordt);

                          ghrconn.Close();

                      }

      and this is my ConnectionString:

      (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.111)(PORT = 1500))) (CONNECT_DATA = (SID = HRMS)));User Id=userid;Password=userpw"

       

      Thanks in Advance...