Problem compile SQLlite

Discussion in 'Questions (Windows Mobile)' started by manu, Apr 29, 2007.

  1. manu

    manu Active Member Licensed User

    Hi.

    I am happy that the forum is in progress again.

    I have a problem, I am trying to compile the "Example SQL", but he gives me an error, "format not files SQLDesktop.dll" been worth.


    You can help me
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    You should install .Net 2.0.
    See this page: www.basic4ppc.com/netcf2.html
    You could find the compiled version of the SQLExample on the downloads page (named SQLCompiled).
     
  3. manu

    manu Active Member Licensed User

    Ok ThanK you

    Thank you Erel

    All correct one works
     
  4. manu

    manu Active Member Licensed User

    Hi.

    In the Pc all works well, but in the Pda he gives an error "Error loading program. \ programa\SinkFactur Files 3.0\SQLDevice.dll"

    I have copied the file Basic4ppc.exe.config in different places and it follows me giving error

    thank you
     
  5. Erel

    Erel Administrator Staff Member Licensed User

    Are you trying to run a compiled application?
    If yes, then you should put in the same folder of your application the Basic4ppc.exe.config and rename it to YourApplicationName.exe.config (change YourApplicationName).
     
  6. manu

    manu Active Member Licensed User

    ok Erel

    Solved, but now my gives another error.

    Error Loading Program.No was the name of the file or of the assembler

    'SystemData.SQLite,
    Version=1.0.40.0,
    Culture=neutral,
    ..... Or

    Thank you
     
  7. Erel

    Erel Administrator Staff Member Licensed User

  8. manu

    manu Active Member Licensed User

    Ok.Erel,

    solved the problem.

    Thank you
     
  9. hung

    hung Member Licensed User

    sqlite version problem?

    I downloaded and installed .Net framework 2.0 as in the instruction. Things went smooth except when I on desktop open the SQL.sbp, the attached error prompts.


    But the compiled version works fine in my PPC.
     
  10. Erel

    Erel Administrator Staff Member Licensed User

    As the error says you need to copy System.Data.SQLite.DLL from the Desktop folder (in the SQL library zip) to your application folder.
     
  11. hung

    hung Member Licensed User

    The error prompts when I use "Basic4ppc Desktop" open the SQL.sbp in the sqlexample folder.

    The system.data.sqlite.dll, sqldesktop.dll and sql.sbp are in same folder.

    And I found another system.data.sqlite.dll in the "Basic4ppc Desktop" library folder but its file size is 568K that is not same as the 450K of the dll in the zip file.

    The erorr prompts after I download latest dotnet and install it.
     
  12. Erel

    Erel Administrator Staff Member Licensed User

    The zip file includes two folders.
    Under the Desktop folder there is the desktop dll: System.data.sqlite.dll - 568k.
    The 450k file is the device file.
    I recommend you to delete all the System.data.sqlite.dll files.
    Download it again, and copy the 568k one to c:\Program files\Anywhere Software\Basic4ppc Desktop. (not the libraries folder)
     
  13. hung

    hung Member Licensed User

    I unzip again and put the 568k file in the sqlexample folder, everything works fine now. Thanks.
     
Loading...