Mobile: ORA-12571 Exception
Posted: Mon 08 May 2006 13:55
Hi,
i downloaded oradirect mobile component and i am using it on .NET 2003 for establishing connection between ppc application and Oracle database (8.1.6).
After fetching 960 items in 'stname' i reveive an ORA-12571 (''TNS packet writer failure') execption (below). There are aprox. 1500 items in the database. What went wrong??
i downloaded oradirect mobile component and i am using it on .NET 2003 for establishing connection between ppc application and Oracle database (8.1.6).
After fetching 960 items in 'stname' i reveive an ORA-12571 (''TNS packet writer failure') execption (below). There are aprox. 1500 items in the database. What went wrong??
Code: Select all
Dim oConnection As New OracleConnection
Dim oCommand As OracleCommand
Dim oReader As OracleDataReader
Dim stname As String
Try
oConnection.ConnectionString = "User Id=scott;Password=tiger;Data Source=192.168.99.2;Port=1521;SID=bart"
oConnection.Open()
oCommand = oConnection.CreateCommand
oCommand.CommandType = CommandType.Text
oCommand.CommandText = "SELECT lief_nr,lief_name FROM lieferant ORDER BY lief_name"
oReader = oCommand.ExecuteReader
While oReader.Read
stname = oReader.GetString(oReader.GetOrdinal("lief_name"))
'aLief.Add(oLief)
End While
oReader.Close()
oConnection.Close()
Catch ex As Exception
MessageBox.Show(ex.ToString & " " & nNr)
End Try