Problem with B4P and SQLite after close the application

Discussion in 'Questions (Windows Mobile)' started by Fontanus, Aug 9, 2007.

  1. Fontanus

    Fontanus Member Licensed User

    Hello to everyone,

    I raise a problem with my small program in connection with SQLite. During the execution of the program there aren't any faults but after completion on the PPC with WM5 an error message appears. This error message dies me the more often, the once in a while have.The access to the database is quite consistently made by opening and close of the connection accessed the database

    Here are examples of the error message:
    Fehlermeldung:

    Unerwarteter Fehler in EnRoute.exe. Klicken Sie auf "Beenden", und starten Sie das Programm neu.Weitere Informationen zu diesem Fehler erhalten Sie, indem Sie auf "Details" klicken.


    Details:
    EnRoute.exe
    ArgumentException

    bei
    System.PInvoke.EE.Runtime_InteropServices_GCHandle_InternalGet()

    bei
    System.WeakReference.get_IsAlive()

    bei
    System.Data.SQLite.SQLiteConnection.ClearReferences()

    bei
    System.Data.SQLite.SQLiteConnection.RemoveCommand()

    bei
    System.Data.SQLite.SQLiteCommand.set_Connection()

    bei
    System.Data.SQLite.SQLiteCommand.Dispose()

    bei
    System.Data.SQLite.SQLiteCommand.Finalize()


    Details:
    EnRoute.exe
    ArgumentException

    bei
    System.PInvoke.EE.Runtime_InteropServices_GCHandle_InternalGet()

    bei
    System.WeakReference.get_IsAlive()

    bei
    System.Data.SQLite.SQLiteConnection.ClearReferences()


    bei
    System.Data.SQLite.SQLiteCommand.RemoveCommand()

    bei
    System.Data.SQLite.SQLiteCommand.set_Connection()

    bei
    System.Data.SQLite.SQLiteCommand.Dispose()

    bei
    System.ComponentModel.Component.Finalize()

    bei
    System.Data.SQLite.SQLiteCommand.Finalize()


    Somebody can give me a tip as I can solve the problem?

    Best regards

    Fontanus
     
  2. Erel

    Erel Administrator Staff Member Licensed User

  3. Fontanus

    Fontanus Member Licensed User

    Yes, i have...

    ... the SQL Library 1.20 installed. The application runs very good and free from errors, but after closing, it's come the errors.
     
  4. Erel

    Erel Administrator Staff Member Licensed User

    You should only open the connection once at startup.
     
  5. Fontanus

    Fontanus Member Licensed User

    Thank you very much. Now, i have changed the open connection in the Sub APP_START and i close the connection before the application is terminated. In the moment, the application is errorfree.
    Best regards
    Fontanus
     
Loading...