Hi, I've got this error when connecting to that Oracle DB with the following VB codes.
OleDbException was unhandled ORA-12560: TNS:protocol adapter error
Private Sub Form1_Loaded(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Activated Dim conn As New OleDbConnection("SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=my_pc)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=XE)));Provider=SQLOLEDB;User ID=abc_schema;Password=wsabc;") Dim ret_val As Integer = 0
Try conn.Open() ...
In the beginning of the program, I've put this
The error is from the above line in italic.
Thanks & Best Regards, HuaMin Chen. In Hong Kong, China.
(PAGE 452) ORA-12560: TNS:protocol adapter error Action: The listener was unable to start a process connecting the user to thedatabase server. Cause: Perform these steps: 1. Turn on tracing and repeat the operation. 2. Evaluate the contents of the trace ﬁle to diagnose the problem.