dcsimg
Results 1 to 5 of 5

Thread: Newer SQLite3 dll (stdcall) version?

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2015
    Location
    Finland
    Posts
    654

    Newer SQLite3 dll (stdcall) version?

    I have one project in hand, which needs to consume sqlite3 format database, but in read-only mode.

    Hence question - does anybody know, is there available sqlite driver, which has support for sqlite3_open_v2 and sqlite3_close_v2 (read-only mode) functions?

    Windows 10 has winsqlite3.dll inbuilt, but application needs to support older windows versions (7, 8.1).

  2. #2
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    1,815

    Re: Newer SQLite3 dll (stdcall) version?

    Why not compile it yourself to stdcall?
    Chapter 12
    https://www.sqlite.org/compile.html
    One System to rule them all, One IDE to find them,
    One Code to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    For health reasons i try to avoid reading unformatted Code

  3. #3
    PowerPoster
    Join Date
    Jun 2013
    Posts
    4,235

    Re: Newer SQLite3 dll (stdcall) version?

    With the SQLite-wrapper in vbRichClient5 you can open a SQLite-db readonly this way:
    Code:
    Dim Cnn As cConnection
    Set Cnn = New_c.Connection 
        Cnn.OpenDBReadOnly YourFileName  ' this will use the sqlite3_open_v2 API under the covers 
    HTH

    Olaf

  4. #4
    Frenzied Member
    Join Date
    Jun 2012
    Posts
    1,227

    Re: Newer SQLite3 dll (stdcall) version?

    StdCall flat API dll: (v3024000;2018-06-04)
    https://github.com/VBForumsCommunity/sqlite3win32

  5. #5

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2015
    Location
    Finland
    Posts
    654

    Re: Newer SQLite3 dll (stdcall) version?

    Zvoni, thanks looked that option and compiled, but for some reason function exports could not be found (453 error), defined them in sqlite3.def file. Have to investigate.

    Olaf, thanks, but this app is running in memory restricted device, no room for such a large libraries.

    Krool flat api could be solution, but it is not combatible (with older stdcall dll impelmentations) fex. sqlite3_get_table function needs more work to use.

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width