[RESOLVED] Sqlite3 on Windows 10 with VB6-VBForums
Results 1 to 12 of 12

Thread: [RESOLVED] Sqlite3 on Windows 10 with VB6

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    Resolved [RESOLVED] Sqlite3 on Windows 10 with VB6

    I'm running Windows 10 64 bit and have a Sqlite v3.9.2 database and would like to connect my old VB6 to the database.
    What is the best way to connect the two, something that is simple, not a procedure that requires 6 dll's. I have seen some products that only connect to Sqlite version 2.

    Thanks

  2. #2
    PowerPoster
    Join Date
    Oct 2013
    Posts
    2,759

    Re: Sqlite3 on Windows 10 with VB6

    You can use vbRichClient for this. This toolset does require some DLLs.
    www.vbrichclient.com

  3. #3

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    Re: Sqlite3 on Windows 10 with VB6

    Thanks, I've got installed, but their own code has problems. I think the dll's are installed in the wrong directory.

  4. #4
    PowerPoster
    Join Date
    Oct 2013
    Posts
    2,759

    Re: Sqlite3 on Windows 10 with VB6

    Better tell us what you have done.
    Because I use this toolset and it works for me.

  5. #5

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    Re: Sqlite3 on Windows 10 with VB6

    I had the dll files in a download folder, so I copied them toProgramfiles(x86)/vb98 with some other vbfiles. I then discovered some tutorials and demos, so I'll try them out later today and let you know what I find.

  6. #6

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    Re: Sqlite3 on Windows 10 with VB6

    Well I tried running the Nwnd.db demo which produced the error message:
    Run-time error -2147024770 (8007007e)
    Automation error
    the specified module could not be found.

    In the Form-Load module
    at line lVersion = "SQLite-Version: " & New_c.Connection.Version
    ---------------------------------------------------------------------------

    In all the zip files was an install procedure for the winhlp32 help files, so I attempted to install that which produced the following:

    Terminating all possible running instances of WinHlp32...
    ERROR: The process "winhlp32.exe" not found.

    Taking the ownership of system's existing winhlp32.exe.mui...

    SUCCESS: The file (or folder): "C:\WINDOWS\en-US\winhlp32.exe.mui" now owned by user "DESKTOP-I546VS1\Me".

    Granting Me full-access permission to system's existing winhlp32.exe.mui...
    processed file: C:\WINDOWS\en-US\winhlp32.exe.mui
    Successfully processed 1 files; Failed processing 0 files

    Copying winhlp32.exe.mui to system...
    1 File(s) copied

    Taking the ownership of system's existing winhlp32.exe...

    SUCCESS: The file (or folder): "C:\WINDOWS\winhlp32.exe" now owned by user "DESKTOP-I546VS1\Me".

    Granting Me full-access permission to system's existing winhlp32.exe...
    processed file: C:\WINDOWS\winhlp32.exe
    Successfully processed 1 files; Failed processing 0 files

    Copying winhlp32.exe to system...
    1 File(s) copied

    Updating Registry entries...
    ERROR: Access is denied.
    ERROR: Access is denied.
    ERROR: Access is denied.
    ERROR: Access is denied.

    Error installing WinHlp32

    Setup will now exit.

    Any help here would be appreciated.

  7. #7

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    Re: Sqlite3 on Windows 10 with VB6

    Well I've got one of their demos to work which generates a Sqlite database which I can open with DB Browser for Sqlite.
    I should be able to build a menu, forms and access my database from here.
    I still have the issue with the help file, but I can work on it as time goes by.
    THanks for your hekp.

  8. #8
    PowerPoster
    Join Date
    Oct 2013
    Posts
    2,759

    Re: Sqlite3 on Windows 10 with VB6

    Sorry I missed your replies somehow.
    Which ZIP file with winhelp installation are you referring too?

  9. #9

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    Re: Sqlite3 on Windows 10 with VB6

    winhlp32-windows-7-10-x86-64.zip

  10. #10
    Frenzied Member gibra's Avatar
    Join Date
    Oct 2009
    Location
    ITALY
    Posts
    1,331

    Re: Sqlite3 on Windows 10 with VB6

    Quote Originally Posted by Cpat View Post
    winhlp32-windows-7-10-x86-64.zip
    You must run the INSTALL.CMD as Administrator.

    Try this:

    - extract the zip contents into a folder (i.e. winhlp10)
    - click to Start button
    - enter: cmd (some links appears)
    - right-click to Commands Prompt link, a menu popup, from menu choose: Run ad Administrator
    - from black window navigate to folder where is INSTALL.CMD, winhlp32.exe and winhlp32.exe.mui
    (i.e. enter: CD winhlp10 then press Enter key)
    - run INSTALL.CMD

    Done.

  11. #11

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    Re: Sqlite3 on Windows 10 with VB6

    Running it as administrator fixed it.

    Thanks for everybody's help!

  12. #12
    PowerPoster
    Join Date
    Jun 2013
    Posts
    3,066

    Re: Sqlite3 on Windows 10 with VB6

    Quote Originally Posted by Cpat View Post
    winhlp32-windows-7-10-x86-64.zip
    Not sure, why the above should be needed, or from where this needs to be downloaded...

    A vbRichClient5.chm File (which "just works" on my Win8) is available on the site of Forum-Member "DrUnicode"
    (who thankfully compiles chm's from the recent RichClient-libs).



    Here is a link to the recent CHM: http://www.cyberactivex.com/Download/CairoDocs.zip

    As for the SQLite-VB6-examples which are available for download here: http://www.vbrichclient.com/#/en/Demos/SQLite/

    These should all work from their respective Folder (after unzipping the Tutorial-content).
    A necessary requirement is, that you register (per regsvr32 in Admin-Mode) the vbRichClient5.dll (which is a COM-Dll) prior to running these VB6-Projects,
    otherwise you will get the Error-Message you have already reported.

    HTH

    Olaf

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

Survey posted by VBForums.