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] -----------------------------------------------------------------------------
