×

Discussion Board

Results 1 to 9 of 9
  1. #1
    Registered User
    Join Date
    May 2011
    Posts
    28

    Using SQLite on FP1 device

    Hello!
    I need to use SQL API (RSqlDatabase ...) for my program (inc FP1 devices)..

    I install to support this feature on device symbiansql_v9.2.sis

    But when i start my app - i get "Unable to execute file for security reasons (-46)" error...

    P.S. My app capabilities is ReadUserData WriteUserData NetworkControl WriteDeviceData
    On newest devices (FP2 and higher) app work fine..

    Maybe someone know solution of this problem?

  2. #2
    Nokia Developer Moderator
    Join Date
    Mar 2003
    Location
    Lempäälä/Finland
    Posts
    29,165

    Re: Using SQLite on FP1 device

    the name symbiansql_v9.2.sis would indicate that the file is indeed intented to be used with 3rd ed FP2, so try getting the version which would be supported by 3rd ed FP1 device.

  3. #3
    Registered User
    Join Date
    May 2011
    Posts
    28

    Re: Using SQLite on FP1 device

    In my you are wrong...

    S60 3rd Edition 3.0 9.1
    S60 3rd Edition, Feature Pack 1 3.1 9.2
    S60 3rd Edition, Feature Pack 2 3.2 9.3
    ................
    http://en.wikipedia.org/wiki/Series_60
    Please correct me if I'm wrong....

    And since FP2 this component is built-in...

  4. #4
    Registered User
    Join Date
    May 2007
    Posts
    45

    Re: Using SQLite on FP1 device

    Sorry, If my suggestion doesn't sound smart, but, please, use ALL -TCB -DRM -AllFiles in capability line, rebuild for phone and try to install. In meantime I'm going to find out that SIS and to make a little analysis for you

  5. #5
    Nokia Developer Moderator
    Join Date
    Feb 2006
    Location
    Oslo, Norway
    Posts
    28,740

    Re: Using SQLite on FP1 device

    There is a rule about .dll-s: a .exe can not use .dll-s having less capabilities. I could not manage to find references to symbiansql_v9.2.sis on the 'more official' sites, so I would assume that it is distributed as a self-signed package, having the the simplest capabilities only (R/WUserData, NetworkServices, LocalServices, UserEnvironment). In this case your code with WriteDeviceData+NetworkControl can not load this .dll, and -46 comes.
    You can either rebuild that .dll for yourself (if the source is provided - if it is the BerkelyDB-port-with-OpenC-success-story, it might be available somewhere), or you can do some magic with unpacking the .sis, adding the capabilities to the .dll and packing it with your application - just in this case it will clash with other applications using the same component.

    EDIT: yes, I have to agree, that suggestion in #4 is not smart, unless it also speaks about rebuilding the database component.
    Last edited by wizard_hu_; 2012-03-07 at 10:10.

  6. #6
    Registered User
    Join Date
    May 2007
    Posts
    45

    Re: Using SQLite on FP1 device

    Thanks wizard_hu_, much apreciate
    lexamor, is it possible to put somewhere that file and give us link to have a review. I wasn't able to find that file
    If so, I could change also capabilities of DLL without rebuilding.

  7. #7
    Registered User
    Join Date
    May 2011
    Posts
    28

    Re: Using SQLite on FP1 device

    Link to file: http://www.2shared.com/file/xLLHplVZ...ansql_v92.html
    2. http://www.sendspace.com/file/1mcw96

    If you get positive results please let us know..))

    EDIT: To phone installed files: sqlsrv.exe and sqldb.dll
    Last edited by lexamor; 2012-03-07 at 10:54.

  8. #8
    Nokia Developer Moderator
    Join Date
    Mar 2003
    Location
    Lempäälä/Finland
    Posts
    29,165

    Re: Using SQLite on FP1 device

    I would strongly suggest contacting the original developer. In general it is definitely not advisable on modifying somebody else's binaries, as well as it can be illegal, depending on the rights the original developer likes to keep for the content.

  9. #9
    Registered User
    Join Date
    May 2007
    Posts
    45

    Re: Using SQLite on FP1 device

    Hi lexamor. After small review I detected that guys which signed that file were so funny and gave us a little unusable SIS with spent 10EUR or much and for your headache it's already symbian signed.

    Let me explain. They used the following capability list for DLL:
    Code:
    PowerMgmt
    ReadDeviceData
    WriteDeviceData
    TrustedUI
    ProtServ
    SwEvent
    NetworkServices
    LocalServices
    WriteUserData
    Location
    SurroundingsDD
    UserEnvironment
    Looks absolutely reasonable for Express Signed but.... in being so funny to forget including ReadUserData they made their sis useless, my apologies. Even not NetworkControl which is from Certified Signing set Originally, wizard_hu_ was right about capabilities (and I'm but with non-smart message on a forum ).

    What to do:
    - Symbianyucca is right - you should be care about their rights and generally you must to contact them to receive: we don't support it more
    - then you could update capability&UID set with elftran tool (in sdk) and to be available to sign it inside of your package... but....

    In case of detecting this 'stealing' by owners you could have many funny assizes to compensate them potential money loose

    The next step is yours. Decide

Similar Threads

  1. Replies: 7
    Last Post: 2010-07-14, 17:05
  2. SQLite??
    By ambkps in forum Symbian
    Replies: 6
    Last Post: 2010-01-11, 08:05
  3. SQLite on device problems
    By frizi in forum Symbian
    Replies: 2
    Last Post: 2008-07-28, 07:01

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
×