Using SQLite with Classic ASP

Question

I am creating a “quick small” application that needs a small database.
I want to use classic ASP (i.e. not ASP.NET), and I'm curious about SQLite for the database.

Can I use SQLite from classic ASP?

How to open / create / use SQLite database from ASP?

Any help / pointers gratefully received!

Answer 1

It is easily possible.

• First install the ODBC driver from http://www.ch-werner.de/sqliteodbc/
• Then you can connect, for example. DRIVER=SQLite3 ODBC Driver;Database=mydb.sqlite;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;

ajaxed library, . ...