[RESOLVED] SQLite3

[Carlos Rocha]

You have a few links here
http://www.vbforums.com/showthread.p...ent-Framework)

[carpboy]

You have a few links here
http://www.vbforums.com/showthread.p...ent-Framework)

Thanks for the info Carlos.

I've been through those, been through them all it seems, and they highlight exactly the difficulties I am having.

The two photo demos crash in my VB6, complaining something about an ActiveX control.

One link is using ODBC, which I don't want.

Treeview is based on Jet.

The github stuff is still lacking any info as to how to use the dll, as is its webpage for the vbrichclient.

So this isn't so simple, the info just isn't quite there.

Thanks.

[Schmidt]

Thanks for the info Carlos.
I've been through those, been through them all it seems, and they highlight exactly the difficulties I am having.
The two photo demos crash in my VB6, complaining something about an ActiveX control.

I'd stop right here - and want to ask you, what problem you had *exactly*, whilst trying to
run the demo under the following link:
http://www.vbrichclient.com/Download...DemoSQLite.zip

Note, that the Demo in question does not reference any external ActiveX-*Control* -
its only COM-reference is that to a Dll (vbRichClient5) - and if you don't register
this COM-Dll properly beforehand, nothing which depends on it will work...

The above PhotoDemo-zip also contains a Readme.txt where is stated:

 
  It (the Demo) depends on the SQLite-wrapper which comes with the RichClient-Framework
  (download from: http://www.vbRichClient.com/#/en/Downloads.htm)

Then - furthermore, in the Download-Section of vbRichClient.com is clearly explained:

 
  Out of the contained dlls you'd have only:
  vbRichClient5.dll   <-- this one here to register (per regsvr32 in Admin-Mode) 
  vb_cairo_sqlite.dll
  DirectCOM.dll
  In addition, please keep those Dlls always together in their Folder - also when you deploy them with your App.

So this isn't so simple, the info just isn't quite there.

Given what I've just posted above, that's not quite true - the PhotoDemo-example above
is a nice one, because it is still very simple - and because it demonstrates similarities
to ADO, referring to a "twin-like"-ADO/JET-Demo, written by dilettante, so you can compare
with ADO-based code (Connections and Recordsets) yourself - in short: if you know how to
work with ADO-recordsets, then you will not have any problems with the vbRichClient-
SQLite-wrapperclasses (especially the cRecordset-class, since it behaves nearly identical).

Just get the above linked PhotoDemo-running - and for that you will have to put the 3
framework-dlls into a path on your developer-machine - and after that register only
the vbRichClient5.dll. When that is done, you should be able to startup and run at least
the SQLite-based PhotoDemo without problems - if not so, posting the exact Error-
message would be very helpful.

Olaf

[carpboy]

Thanks for taking the time to reply Olaf.

I'd stop right here - and want to ask you, what problem you had *exactly*, whilst trying to
run the demo under the following link:
http://www.vbrichclient.com/Download...DemoSQLite.zip

ActiveX component can't create object.

This is in form_load, looking to see if the database exists.

Note, that the Demo in question does not reference any external ActiveX-*Control* -
its only COM-reference is that to a Dll (vbRichClient5) - and if you don't register
this COM-Dll properly beforehand, nothing which depends on it will work...

I have all the dll's present and, reading your post, again started playing with them. The problems I was having prior was when I would try to register vbrichclient5 it kept telling me that it found the file but couldn't find the entry point. I must have done this 6 times. I then moved the dll to \system32 and tried registering it there and that failed with just a generic 'couldn't find module' message.

So in good faith to your efforts of explaining all this I reattempted as you directed, including registering it in the project folder, and it worked just perfectly fine this time. I certainly can't explain why but rest assured I had tried this over and over and over the last two days.

When I wrote that the "the info just isn't quite there" I was referring to all references to how to do this, not just your part. I have been hit with broken links, VB projects not running, good examples but not v3 SQLite compatible, stuff like that. It has been very frustrating.

So I will play with your efforts and again, thanks for taking the time to write.

[Schmidt]

ActiveX component can't create object.
This is in form_load, looking to see if the database exists.

Yes, that's the error one gets, when vbRichClient5.dll is not (yet) properly registered
per regsvr32.exe on the developer-machine in question.

I have all the dll's present and, reading your post, again started playing with them. The problems I was having prior was when I would try to register vbrichclient5 it kept telling me that it found the file but couldn't find the entry point. I must have done this 6 times. I then moved the dll to \system32 and tried registering it there and that failed with just a generic 'couldn't find module' message.

That's IMO related to the requirement (which was pointed out on the download-page),
that the 3 Dlls of this MiniFramework need to be kept together in the same Folder.

Isolating the vbRichClient5.dll from its "satellite-companion-dlls" will make registering-
attempts fail, because of a "non-delayed-load-dependency" to vb_cairo_sqlite.dll (due
to a internal typelib that is).

So in good faith to your efforts of explaining all this I reattempted as you directed, including registering it in the project folder, and it worked just perfectly fine this time.

Glad it's working now.

And you don't have to place the 3 Framework-Dlls in the ProjectFolder of a certain Demo-Project -
just in *some* fixed Folder on your Dev-machine, where you want to place "shared COMponents" -
e.g. I'm placing the 3 Dlls on my Test-VMs on C:\RC5\... - followed by registering the
vbRichClient5.dll within that C:\RC5\-folder. That should be it - and you can forget about the
framework then (until you are in the phase of preparing a Setup for Redistribution).

All the Demo-Downloads (any Demo-download which depends on the 3 RC5-Base-Dlls)
will work directly from e.g.: C:\DemoDownloads\SomeSQLiteOrRC5Demo\Some.vbp, ...
so there's no need, to place any framework-Dlls within those Demo-Folders - and also no
need to place the RC5 framework-Dlls within System32 or SYSWOW64.

Since your memory is still fresh - and there seem to be others as well, who were stumbling over the
installation of the framework-libs (reporting the same "Error": [ActiveX component can't create object]... -
what do you think I should change on the WebSites Download-Section, to make the first
installation-attempt more successful for "RichClient-Newbies"?
Is the placement of my installation-advice on the site too small (or otherwise not prominent enough) -
or is the wording not entirely clear - any advise is welcome to make it easier for the "next guy".


Olaf

[Bonnie West]

what do you think I should change on the WebSites Download-Section, to make the first
installation-attempt more successful for "RichClient-Newbies"?
Is the placement of my installation-advice on the site too small (or otherwise not prominent enough) -
or is the wording not entirely clear - any advise is welcome to make it easier for the "next guy".

How about providing a proper installer in addition to the DIY archive?

[carpboy]

Olaf,

I'm not certain what could be done to make it any clearer, looking back it is quite obvious you state to have the three all together and register the one. I can't explain what exactly happened to me, god only knows, but it seem pretty apparent what one needs to do.

One thing that would be cool would be a couple paragraphs of information. I'd like to see what the methods are and how they are invoked, nothing detailed, just a summary.

Thanks again.