ORA-12560: TNS:protocol adapter error

[ashima515]

Hi

Whenevr I try to connect my ASP.Net form to Oracle DB I get the follwoing error:
ORA-12560: TNS:protocol adapter error

here's the code:

Dim con As New OracleConnection("Password=tiger;" & _
"User ID=scott")

con.Open()
Dim myCMD As New OracleCommand
myCMD.Connection = con
myCMD.CommandText = "select password from emp_password where username='" + txtusername.Text + "'"
myCMD.CommandType = CommandType.Text
Dim myReader As OracleDataReader
myReader = myCMD.ExecuteReader()
myReader.Read()
If Not (txtpassword.Text = myReader.Item("password")) Then
lblalert.Visible = True

Else
Response.Redirect("myaccount.aspx")
End If
myReader.Close()
con.Close()


Please help as soon as possible....

Ashima

[jonathan184]

go to this link:

http://www.cryer.co.uk/brian/oracle/ORA12560.htm