Convert SQL Server DB to SQLite DB

Convert SQL Server DB to SQLite DB (CodeProject
C# Utility to automatically do the conversion from SQL Server DB to SQLite DB.

Sqlite Wrappers - COM Wrappers / Visual Basic DLLs

SQLite Wrappers

COM Wrappers / Visual Basic DLLs
SQLitePlus Top selling COM Wrapper DLL and Database Explorer that extends the functionality of SQLite to add important features such as on-the-fly Encryption and Compression, .csv data import and export, stored Procedures, and an ADO-like object model. Also includes an excellent Database Explorer/Query Analyzer for visualizing and working with your Sqlite data. http://www.sqliteplus.com/

System.Data.SQLite is an enhanced version of the original SQLite database engine. It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll). It has no linker dependency on the .NET runtime so it can be distributed independently of .NET, yet embedded in the binary is a complete ADO.NET 2.0 provider for full managed development.

dhSQLite, free ADO-like COM Wrapper. Current Version 1.2 (engine-version 3.4.0)... great performance, builtin encryption, optimized for disconnected Recordset-scenarios, super fast serialization/deserialization with 'UpdateBatch', Connection-, Recordset-, Field- and Command-Objects, DB-Schema-Obj-Model, builtin VB-Function-Set (DateDiff, DatePart, Format$, etc.), userdefinable Functions/Collations, FTS2-support, Overridden Like, Upper, Lower and NoCase means UTF8-awareness without ICU ... combinable with a free COM-RPC-Server for usage in real AppServer-scenarios in your LAN or over the Internet (due to builtin protocol-compression and -encryption).

SQLite3VB - Making SQLite VB Compatible. Teaches how to modify the SQLite C source code to make it VB-friendly. You end up with a non-COM DLL that you can call from a VB Classic project. [Sept 2007: The instructions will let you compile the project yourself (might require some common sense!) or download the compiled DLL - Currently 3.4.2]

AGS_SQLite SQLite wrapper 1.1.0 for Visual Basic is based on SQLite 2.8.13, and includes source + sample program. The AGS_SQLite.DLL file contains all of the functions that SQLite.DLL has, so all you need is AGS_SQLite.DLL. Geckoware was formerly known as AGSoftware.

SqLite2X : Free ActiveX wrapper with sources (2005-Nov-29 [mpot] sqlite 2.x only)

SleepSleep sqlite wrapper for vb6 - wrapper dll coded using fasm. Come with wrapper dll source code, a vb6 "sqlite browser" project files to show how to use the dll and a .bas file for you to attach on your project to use the dll instantly. (sqlite 2.x only)
(July 2007: dead link) qrfSQL2 Database Engine
(July 2007: dead link) SQLITEDB by Javier S. Bermudez
(July 2007: dead link) ADOSQLite VB6 wrapper requires AGS_SQLite.dll from ag-software (2005-Nov-29 [mpot] sqlite 2.x only)
(Apr, 2008: Dead link) Pivotal Solutions' non-COM DLL dynamically binds to SQLite DLL at runtime and so doesn't need recompiling everytime a new version of SQLite is released, ie. you'll need to distribute both PS' DLL and SQLite's DLL. (Apr, 2008: Dead link)
(Apr, 2008: No longer maintained) SQLiteDB is an ActiveX DLL built on top of SQLite (i.e. you only need to distribute SQLiteDb.dll) and is designed as an ADO replacement. Available in free and commercial versions. Although the site has not been updated recently, the developer does release frequent updates via the message board. The current SQLiteDB Professional build is based off of SQLite 3.4.0. The demo (built on SQLite 3.3.6) comes with plenty of examples and sample applications.

LiteX: COM DLL wrapper for SQLite3 (ATL). ("Release date: 16-04-2008, Used SQLite3 library version: 3.5.7.")
SQLite 3.x compatible
Source code provided (SVN repository: http://trac2.assembla.com/aIPblab5qr3zkdab7jnrAJ/browser)
Useful sample code
Works very well
Excellent wrapper for VBA
(Apr, 2008: Dead link) http://perso.wanadoo.fr/jveritecontribs/DAOSqlite.zip DAO like Sqlite Wrapper for VB6} (2005-Nov-29 [mpot] sqlite 2.x only) (2005-Nov-14, [Michael B. Johnson] No sample code on usage that I could see.)


Drivers
libdbi (C abstraction lib) driver for SQLite. http://libdbi-drivers.sourceforge.net/
ODBC driver for SQLite. http://www.ch-werner.de/sqliteodbc/.
KexiDB driver for SQLite. Can be also used with KexiDB library for other apps than Kexi. http://webcvs.kde.org/cgi-bin/cvsweb.cgi/koffice/kexi/kexidb/drivers/sqlite/
SQLite OLEDB Provider. http://CherryCitySoftware.com/ccs/Home/Default.aspx.
SQLite2007 Pro ODBC Driver, the first free ODBC Driver which have supported for accessing encrypted database that was build with SQLite2007 Pro Enterprise Manager. http://osenxpsuite.net/xpsuite/sqliteodbc2007.html


.NET Framework
ADO.NET 2.0/VS2005 Data Provider for SQLite Supports Full and Compact Framework, Visual Studio Design-Time Support.
.NET Mono ADO.NET provider for SQLite
myGeneration - a freeware template based code generation tool that supports SQLite and many other databases. With this tool, you can generate a middle tier for your database in practically any language
Updated! LightSpeed - .NET O/R Mapper with full support for SQLite. 100% .NET 2.0. Supports LINQ to SQLite - http://www.mindscape.co.nz/products/lightspeed/
(Apr, 2008: Deadware) ADO.NET Data Provider for SQLite (.NET Framework 1.1). Supports both SQLite 2 and 3, Full and Compact Framework.
(Apr, 2008: Deadware) qrfSQL2 Database Engine - an abstractions and modified version of SQLite optimized to run on Windows CE devices (Handhelds, PocketPC's, Smartphones). Runs on all Windows CE versions since WCE 2.10. Runs also on Win32, Cygwin and Linux operating systems. Provider a high-level (ADO style) API to quick create robust applications. Native API's for C, C++, Delphi, COM (any ActiveX language such Visual Basic, VBScript, ASP, .NET Framework, etc), Java and SuperWaba.
(Apr, 2008: Latest release June 1, 2006) SQLite-client for NEO: The .NET Entity Objects Framework (persistence-framework). The framework: http://neo.codehaus.org/ The client: http://www.rosa.nl/neo/
(Apr, 2008: "Looking for developers! Please email me!") New! : ManagedSQLite MIT-licensed open source sqlite (v2) wrapper for .NET; written in C#.
.NET wrapper for SQLite 2.8.13 Online Documentation DocumentationSqliteNet
(Apr, 2008: "Last modified: 16:57 29th December 2006") .NET C# wrapper for SQLite (usable with C#, Managed C++ & VB.NET)
newLISP

SQLite2008 Pro ODBC Driver

SQLite2007 Pro ODBC Driver is free ODBC driver for accessing encrypted database that was created by SQLite2008 Pro Enterprise Manager and standard sqlite3 database format.

related tools:

SQLite2008 Pro Enterprise Manager
SQLite2008 Pro Enterprise Manager is a freeware tool that enables you to manage your SQLite3 databases.
Downloads:
Free Version (6Mb )
Last Updated 2008-04-17
Engine version SQLite v3.5.8
Download Now!

Features:
Blob/Image viewer
Built-in FTS1, FTS2 and FTS3 Extention
Built-in LUA Programming Language
Encrypted database support
Export recordset into excel, csv, xml and html format
Import data from Ms Access / MS SQL server
Includes SQLite2008 Pro ODBC Driver
Includes Additional sqlite3 function (compress, decompress, crc32, md5, etc)
Transactions supported
Visual Query Builder

SQLite ODBC Driver (CH. Werner)

SQLite ODBC Driver

SQLiteODBC Documentation
http://www.ch-werner.de/sqliteodbc/html/index.html

Download:
Current version: sqliteodbc.exe

LiteX - an automation wrapper for SQLite3

Space Home litex Assembla
LiteX package consists of:
LiteX Automation – automation wrapper around SQLite3 library. This wrapper is useful if you want to use SQLite3 databases in Visual Basic or any scripting languages such as JScript,VBScript and (my favorite) AutoIt3.
LiteX++ - C++ wrapper around SQLite3 library. This wrapper is useful to build fast SQLite3 database access in your C++ projects.
LiteX ADO .NET provider - beta code. ADO .NET provider for SQLite3 databases to use SQLite3 databases in managed code.
All wrappers comes with full source and are public domain.

Downloads:
Release date: 16-04-2008.
Used SQLite3 library version: 3.5.7.
source and binary here.
documentation here.

SQLite3VB - SQLite + Visual Basic 6

SQLite3VB - VB Compatible SQLite

'// SQL Lite dll declarations:
Private Declare Sub sqlite3_open Lib "SQLite3VB.dll" (ByVal FileName As String, ByRef handle As Long)
Private Declare Sub sqlite3_close Lib "SQLite3VB.dll" (ByVal DB_Handle As Long)
Private Declare Function sqlite3_last_insert_rowid Lib "SQLite3VB.dll" (ByVal DB_Handle As Long) As Long
Private Declare Function sqlite3_changes Lib "SQLite3VB.dll" (ByVal DB_Handle As Long) As Long
Private Declare Function sqlite_get_table Lib "SQLite3VB.dll" (ByVal DB_Handle As Long, ByVal SQLString As String, ByRef ErrStr As String) As Variant()
' sqlite_get_table Returns a 2 dimensional array including column headers
Private Declare Function sqlite_libversion Lib "SQLite3VB.dll" () As String ' Now returns a BSTR
Private Declare Function number_of_rows_from_last_call Lib "SQLite3VB.dll" () As Long
' number_of_rows_from_last_call returns the number of rows from the last sql statement. Use this to ensure you have a valid array

Downloads:Version 3.4.2 (Most Current Build!)SQLite3VB.dll (Zip File)

System.Data.SQLite

System.Data.SQLite
System.Data.SQLite is an enhanced version of the original SQLite database engine. It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll). It has no linker dependency on the .NET runtime so it can be distributed independently of .NET, yet embedded in the binary is a complete ADO.NET 2.0 provider for full managed development.