Mobile: ORA-12571 Exception

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 1
Joined: Mon 08 May 2006 13:23
Location: Berlin, Germany

Mobile: ORA-12571 Exception

Post by Floyd » Mon 08 May 2006 13:55

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

            oConnection.ConnectionString = "User Id=scott;Password=tiger;Data Source=;Port=1521;SID=bart"
            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"))
            End While
        Catch ex As Exception
            MessageBox.Show(ex.ToString & " " & nNr)
        End Try

Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Wed 10 May 2006 06:24

Send us please small demo project to demonstrate the problem to OraDirect .NET support address and include script to create server objects (tables).

Post Reply