c# ora-01017 invalid username/password

Vote count: 0

I have read a few other posts and not quite seem right as i don't have access to the server nor as an admin i am simply a user with a workspace i can create tables and such in my work space and i know it is possible to remotely connect but im not having any luck.

The error i get is ORA-01017: Invalid username/password; login denied.

My code is:

static void Connect()
{
    con = new OracleConnection();
    con.ConnectionString = "Data Source=(DESCRIPTION="
                                          + "(ADDRESS="
                                              +" (PROTOCOL=TCP)"
                                              +" (HOST=**host**)"
                                              +" (PORT=**port**))"
                                          +" (CONNECT_DATA="
                                              +" (SID=**sid**)))"
                                          +"User Id=MATTHEWFARRELL;"
                                          +"Password=PASSWORD;";
    con.Open();
    Console.WriteLine("Connected to Oracle \n\n" + con.ServerVersion);
}

Worse of all i did actually test this with a full uppercase password set to 'PASSWORD' but it was not set that for long.

I have tried:- setting everything to uppercase checking the format i am sending the data i tried adding ' ' around my user/pass this was not liked i read about installing wireshark but while i could do this on my local system i cannot on the other side.

asked 22 secs ago

Matt Farrell

Let's block ads! (Why?)

c# ora-01017 invalid username/password