• What is the difference between 2.8, 3.0 and 3.5?

There are many changes to the architecture of the underlying SQLite engine from 2.8 to 3.0.  One area of major change is BLOB support.  The main differences to SQLitePlus users are as follows:

1. Now there is no need for 6 different SQLite version DLLs - there is only one. 
2. In SQLitePlus 2.8, any field could be encrypted and any non-numeric field could be compressed.  In 3.0, only BLOB-type fields can be encrypted and/or compressed.

There are only small changes differences between the ver 3.0 and 3.5 interfaces.  But each new COM DLL release uses completely different CLSIDs.  This is extremely important to you, because if we were to change the interfaces and use the same CLSIDs, your compiled code would be broken!  Many other products available on the Internet do this all the time, because they don't understand this vital fact!

• Does the SQLitePlus COM DLL require any ODBC or OLEDB drivers (MDAC)?

  No.  The only dependency it has is any of the SQLite DLLs that ship with it, and possibly a Script Engine DLL if you are using Stored Scripts (see below regarding Stored Scripts).  The COM DLL was deliberately created to NOT be an OLEDB driver for the purpose of NOT requiring MDAC to be installed, and for maximum performance (lightning speed).

• Can I use SQLitePlus with .NET?

Yes - .NET fully supports COM objects.  However, we now have a .NET version available, so you might want to use it instead.

• Why should I use the SQLitePlus COM DLL?

It provides a clean interface (no calling C sqlite_* functions); no callbacks to code; no column parsing.  All of that is done for you so you can immediately begin coding your application.  If you are using VB or .NET, SQLitePlus is the best option you have for distributing your application and not needing to hassle with also shipping and installing MDAC.

• Why should I buy the Explorer tool?

The SQLitePlus Database Explorer is required to be able to create Stored Scripts and also to be able to use the "database licensing" mechanism.  Besides this, it is invaluable for working out complex queries and viewing your SQLite databases.  Once you use it, you will not want to give it up.

• Do I need to ship any additional DLLs?

If you decide to use Stored Scripts in your application, you should distribute the applicable script engine DLL with your application.  The fact is that the high majority of Windows PCs will have both vbscript.dll and jscript.dll on them, because they are installed with IE.  But to be sure you should distribute the script engine DLL.