Sqlite – Using SQLite with Classic ASP

asp-classicsqlite

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!

Best Answer

It is easily possible.

First install the ODBC driver from http://www.ch-werner.de/sqliteodbc/
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 ...

Related Solutions

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

Sqlite – How to check in SQLite whether a table exists

I missed that FAQ entry.

Anyway, for future reference, the complete query is:

SELECT name FROM sqlite_master WHERE type='table' AND name='{table_name}';

Where {table_name} is the name of the table to check.

Documentation section for reference: Database File Format. 2.6. Storage Of The SQL Database Schema

This will return a list of tables with the name specified; that is, the cursor will have a count of 0 (does not exist) or a count of 1 (does exist)

Best Answer

Related Solutions

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

Sqlite – How to check in SQLite whether a table exists

Related Topic