Using SQLite with Classic ASP
Asked Answered
B

2

6

I am building a "quick little" app which needs a small database.
I want to use Classic ASP (i.e. not ASP.NET), and I am wondering about SQLite for the database.

It is possible to use SQLite from Classic ASP?

How do I open / create / use a SQLite database from ASP?

Any help / pointers gratefully recieved!

Blisse answered 17/9, 2009 at 8:42 Comment(1)
Just curious, but when you say a small database and a quick little app, why not use the free version MySQL for this? From my understanding, SQLite costs money per year to use, but has faster access and larger limitations.Quatrain
T
10

It is easily possible.

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

I would suggest looking at ajaxed library which offers you a data abstraction for any database. Just configure the connection string and start working ...

Threedimensional answered 18/9, 2009 at 3:16 Comment(0)
A
0

Driver;Database=mydb.sqlite;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;Version=3;

Amadus answered 6/5, 2023 at 4:43 Comment(0)

© 2022 - 2025 — McMap. All rights reserved.