Here are a couple of links to get you started. I suggest you google
your way until you find something which suits you.
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
http://www.freevbcode.com/ShowCode.asp?ID=6893
made hendra wrote:
Thanks John,
Btw, i'm not a sqlite advance nor vb.
I'm not fully understand about vb wrapper. I always using ODBC to
create database connection. Any suggest or clue? where i can find vb
wrapper for sqlite(3).
Tuesday, November 28, 2006, 11:11:04 PM, you wrote:
I cannot help you with ODBC, but if you have an embedded sqlite database
you may be much better off to use the Sqlite API directly rather
than SQL/CLI (ODBC). The Sqlite API handles BLOBs very effectively.
Even if you use something like VB you can find an interface (wrapper)
for the Sqlite API which will work effectively.
You should be aware that Sqlite is not a DBMS server like Sql Server,
Oracle or DB2, it is a library of routines to embed in your application.
If you use it that way the ODBC route does not make much sense and you
lose much of the simplicity of Sqlite.
An Sqlite database is just a single file, so you can see how simple that
makes managing your application. Backups and recovery are so simple.
Distribution of databases cannot be simpler.
Best Regards,
made hendra
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
