There is a package in the SqliteWrappers WIKI to download that does all this - http://www.pivotal-solutions.co.uk/downloads/company/pssqlite.zip
It's a nice VC6 DLL wrapper for VB6 & Java with source code. Dynamically binds to the sqlite.dll and sqlite3.dll at runtime so you don't need to recompile everytime a new sqlite version comes along (why aren't all the wrappers like this???) I've inlcuded the Java wrapper classes with test code and also the VB6 test code. The JNI implementation returns proper native Java types has also been tested on Linux as a shared library. It has been used for ages on various projects here - do what you want with it even if it just serves as some sample code for you. Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg] On Behalf Of Michael Sizaki Sent: 07 January 2006 01:44 To: sqlite-users@sqlite.org Subject: [RBL] [sqlite] How to compile sqlite with VC6? Hi, I want to use sqlite from java on windows. I want to create my own jni binding (different from http://www.ch-werner.de/javasqlite/overview-summary.html). I have VC6 but I'm not a C programmer. How to compile sqlite? Essentially I would like to add a few simple functions to sqlite written in C.... Michael