Mobile: ORA-12571 Exception

Mobile: ORA-12571 Exception

Postby Floyd » 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??

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
Floyd
 
Posts: 1
Joined: Mon 08 May 2006 13:23
Location: Berlin, Germany

Postby 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).
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle