-
Aug 4th, 2017, 09:48 AM
#1
Thread Starter
New Member
[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
-
Aug 6th, 2017, 02:31 AM
#2
Re: Sqlite3 on Windows 10 with VB6
You can use vbRichClient for this. This toolset does require some DLLs.
www.vbrichclient.com
-
Aug 6th, 2017, 04:55 PM
#3
Thread Starter
New Member
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.
-
Aug 7th, 2017, 03:17 AM
#4
Re: Sqlite3 on Windows 10 with VB6
Better tell us what you have done.
Because I use this toolset and it works for me.
-
Aug 7th, 2017, 09:51 AM
#5
Thread Starter
New Member
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.
-
Aug 7th, 2017, 05:03 PM
#6
Thread Starter
New Member
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.
-
Aug 8th, 2017, 04:02 PM
#7
Thread Starter
New Member
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.
-
Aug 9th, 2017, 12:35 AM
#8
Re: Sqlite3 on Windows 10 with VB6
Sorry I missed your replies somehow.
Which ZIP file with winhelp installation are you referring too?
-
Aug 9th, 2017, 09:04 AM
#9
Thread Starter
New Member
Re: Sqlite3 on Windows 10 with VB6
winhlp32-windows-7-10-x86-64.zip
-
Aug 9th, 2017, 10:15 AM
#10
Re: Sqlite3 on Windows 10 with VB6
Originally Posted by Cpat
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.
Last edited by gibra; Aug 9th, 2017 at 10:18 AM.
-
Aug 9th, 2017, 01:34 PM
#11
Thread Starter
New Member
Re: Sqlite3 on Windows 10 with VB6
Running it as administrator fixed it.
Thanks for everybody's help!
-
Aug 11th, 2017, 11:52 PM
#12
Re: Sqlite3 on Windows 10 with VB6
Originally Posted by Cpat
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|