2 Replies Latest reply: Oct 17, 2012 5:47 AM by 905648 RSS

    Need help with ORA-03135

    905648
      Hi all,

      I'm using ODP.NET , OracleDataAccess.dll

      1. cannot find this server message in the documentation
      2. here is the code where this exception occurs:

      Dim dataadapter As New OracleDataAdapter(cmd)
      dataadapter.ReturnProviderSpecificTypes = False
      'dataadapter.SafeMapping.Add("*", GetType(System.String))
      dataadapter.MissingMappingAction = MissingMappingAction.Passthrough
      'dataadapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
      Try

      dataadapter.Fill(Dataset1, table)
      Catch ex As OracleException
      MsgBox(".Fill1 dbAccess: " & ex.Message & " bei Tabelle: " & table & _
      Environment.NewLine & "Aufruf: " & strSQL)
      conn.Close()
      Return False

      many thanks for all replies
        • 1. Re: Need help with ORA-03135
          Tridus
          ORA-03135:
               connection lost contact
          Cause:      1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.
          Action:      1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.

          Start with those two and let us know how it goes. :)
          • 2. Re: Need help with ORA-03135
            905648
            Hello,
            many thanks for Your reply. I don't use properly any timeout parameters.
            Please would You tell me, which changes I have to make in my application.

            You can download my app here:
            http://code.msdn.microsoft.com/Oracle-Dataprovider-for-736ad5af

            regards Ellen