[RESOLVED] SQLite3

[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